﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="erpharmaDataSet" targetNamespace="http://tempuri.org/erpharmaDataSet.xsd" xmlns:mstns="http://tempuri.org/erpharmaDataSet.xsd" xmlns="http://tempuri.org/erpharmaDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="MySettings" AppSettingsPropertyName="erpharmaConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="erpharmaConnectionString (MySettings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.Grid.My.MySettings.GlobalReference.Default.erpharmaConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="dmkhachhangTableAdapter" GeneratorDataComponentClassName="dmkhachhangTableAdapter" Name="dmkhachhang" UserDataComponentName="dmkhachhangTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="erpharmaConnectionString (MySettings)" DbObjectName="erpharma.dbo.dmkhachhang" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[dmkhachhang] WHERE (([ma] = @Original_ma) AND ([ten] = @Original_ten) AND ((@IsNull_mataikhoan = 1 AND [mataikhoan] IS NULL) OR ([mataikhoan] = @Original_mataikhoan)) AND ((@IsNull_diachi = 1 AND [diachi] IS NULL) OR ([diachi] = @Original_diachi)) AND ((@IsNull_maduong = 1 AND [maduong] IS NULL) OR ([maduong] = @Original_maduong)) AND ((@IsNull_maphuong = 1 AND [maphuong] IS NULL) OR ([maphuong] = @Original_maphuong)) AND ((@IsNull_maquan = 1 AND [maquan] IS NULL) OR ([maquan] = @Original_maquan)) AND ((@IsNull_phanloai = 1 AND [phanloai] IS NULL) OR ([phanloai] = @Original_phanloai)) AND ((@IsNull_loaikh = 1 AND [loaikh] IS NULL) OR ([loaikh] = @Original_loaikh)) AND ((@IsNull_ghichu = 1 AND [ghichu] IS NULL) OR ([ghichu] = @Original_ghichu)) AND ((@IsNull_manhomkh = 1 AND [manhomkh] IS NULL) OR ([manhomkh] = @Original_manhomkh)) AND ((@IsNull_machinhanh = 1 AND [machinhanh] IS NULL) OR ([machinhanh] = @Original_machinhanh)) AND ((@IsNull_dienthoai = 1 AND [dienthoai] IS NULL) OR ([dienthoai] = @Original_dienthoai)) AND ((@IsNull_masothue = 1 AND [masothue] IS NULL) OR ([masothue] = @Original_masothue)) AND ((@IsNull_tentat = 1 AND [tentat] IS NULL) OR ([tentat] = @Original_tentat)) AND ((@IsNull_matinh = 1 AND [matinh] IS NULL) OR ([matinh] = @Original_matinh)) AND ((@IsNull_tenkhuynhiemchi = 1 AND [tenkhuynhiemchi] IS NULL) OR ([tenkhuynhiemchi] = @Original_tenkhuynhiemchi)) AND ((@IsNull_daidien1 = 1 AND [daidien1] IS NULL) OR ([daidien1] = @Original_daidien1)) AND ((@IsNull_chucvu1 = 1 AND [chucvu1] IS NULL) OR ([chucvu1] = @Original_chucvu1)) AND ((@IsNull_dienthoai1 = 1 AND [dienthoai1] IS NULL) OR ([dienthoai1] = @Original_dienthoai1)) AND ((@IsNull_daidien2 = 1 AND [daidien2] IS NULL) OR ([daidien2] = @Original_daidien2)) AND ((@IsNull_chucvu2 = 1 AND [chucvu2] IS NULL) OR ([chucvu2] = @Original_chucvu2)) AND ((@IsNull_dienthoai2 = 1 AND [dienthoai2] IS NULL) OR ([dienthoai2] = @Original_dienthoai2)) AND ((@IsNull_maquocgia = 1 AND [maquocgia] IS NULL) OR ([maquocgia] = @Original_maquocgia)) AND ((@IsNull_makhuvuc = 1 AND [makhuvuc] IS NULL) OR ([makhuvuc] = @Original_makhuvuc)) AND ((@IsNull_makhcaptren = 1 AND [makhcaptren] IS NULL) OR ([makhcaptren] = @Original_makhcaptren)) AND ((@IsNull_hanmuctindung = 1 AND [hanmuctindung] IS NULL) OR ([hanmuctindung] = @Original_hanmuctindung)) AND ((@IsNull_hanthanhtoan = 1 AND [hanthanhtoan] IS NULL) OR ([hanthanhtoan] = @Original_hanthanhtoan)) AND ((@IsNull_loaihinhkd = 1 AND [loaihinhkd] IS NULL) OR ([loaihinhkd] = @Original_loaihinhkd)) AND ((@IsNull_ngayphatsinhgd = 1 AND [ngayphatsinhgd] IS NULL) OR ([ngayphatsinhgd] = @Original_ngayphatsinhgd)) AND ((@IsNull_ngaythanhlap = 1 AND [ngaythanhlap] IS NULL) OR ([ngaythanhlap] = @Original_ngaythanhlap)) AND ((@IsNull_nganhnghekd = 1 AND [nganhnghekd] IS NULL) OR ([nganhnghekd] = @Original_nganhnghekd)) AND ((@IsNull_fax = 1 AND [fax] IS NULL) OR ([fax] = @Original_fax)) AND ((@IsNull_macu = 1 AND [macu] IS NULL) OR ([macu] = @Original_macu)) AND ((@IsNull_banggia = 1 AND [banggia] IS NULL) OR ([banggia] = @Original_banggia)) AND ((@IsNull_chietkhau = 1 AND [chietkhau] IS NULL) OR ([chietkhau] = @Original_chietkhau)) AND ((@IsNull_giamgia = 1 AND [giamgia] IS NULL) OR ([giamgia] = @Original_giamgia)) AND ((@IsNull_diachigiaohang = 1 AND [diachigiaohang] IS NULL) OR ([diachigiaohang] = @Original_diachigiaohang)) AND ((@IsNull_loaivitri = 1 AND [loaivitri] IS NULL) OR ([loaivitri] = @Original_loaivitri)) AND ((@IsNull_loaietc = 1 AND [loaietc] IS NULL) OR ([loaietc] = @Original_loaietc)) AND ((@IsNull_chinhanh = 1 AND [chinhanh] IS NULL) OR ([chinhanh] = @Original_chinhanh)) AND ((@IsNull_tinhtrang = 1 AND [tinhtrang] IS NULL) OR ([tinhtrang] = @Original_tinhtrang)) AND ([id] = @Original_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ten" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_mataikhoan" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="mataikhoan" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_mataikhoan" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="mataikhoan" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_diachi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="diachi" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_diachi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="diachi" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_maduong" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="maduong" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_maduong" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="maduong" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_maphuong" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="maphuong" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_maphuong" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="maphuong" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_maquan" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="maquan" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_maquan" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="maquan" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_phanloai" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="phanloai" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_phanloai" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="phanloai" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_loaikh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loaikh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_loaikh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loaikh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ghichu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ghichu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ghichu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ghichu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_manhomkh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="manhomkh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_manhomkh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="manhomkh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_machinhanh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="machinhanh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_machinhanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="machinhanh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dienthoai" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dienthoai" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_dienthoai" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="dienthoai" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_masothue" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="masothue" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_masothue" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="masothue" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tentat" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tentat" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_tentat" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tentat" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_matinh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="matinh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_matinh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="matinh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tenkhuynhiemchi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tenkhuynhiemchi" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_tenkhuynhiemchi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tenkhuynhiemchi" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_daidien1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="daidien1" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_daidien1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="daidien1" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_chucvu1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="chucvu1" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_chucvu1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chucvu1" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dienthoai1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dienthoai1" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_dienthoai1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="dienthoai1" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_daidien2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="daidien2" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_daidien2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="daidien2" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_chucvu2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="chucvu2" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_chucvu2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chucvu2" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dienthoai2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dienthoai2" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_dienthoai2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="dienthoai2" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_maquocgia" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="maquocgia" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_maquocgia" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="maquocgia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_makhuvuc" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="makhuvuc" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_makhuvuc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="makhuvuc" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_makhcaptren" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="makhcaptren" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_makhcaptren" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="makhcaptren" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_hanmuctindung" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="hanmuctindung" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_hanmuctindung" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="hanmuctindung" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_hanthanhtoan" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="hanthanhtoan" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_hanthanhtoan" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="hanthanhtoan" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_loaihinhkd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loaihinhkd" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_loaihinhkd" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loaihinhkd" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ngayphatsinhgd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ngayphatsinhgd" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ngayphatsinhgd" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngayphatsinhgd" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ngaythanhlap" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ngaythanhlap" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ngaythanhlap" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngaythanhlap" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nganhnghekd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nganhnghekd" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_nganhnghekd" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nganhnghekd" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fax" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fax" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_fax" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="fax" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_macu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="macu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_macu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="macu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_banggia" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="banggia" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_banggia" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="banggia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_chietkhau" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="chietkhau" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_chietkhau" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="chietkhau" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_giamgia" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="giamgia" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_giamgia" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="giamgia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_diachigiaohang" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="diachigiaohang" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_diachigiaohang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="diachigiaohang" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_loaivitri" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loaivitri" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_loaivitri" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loaivitri" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_loaietc" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loaietc" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_loaietc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loaietc" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_chinhanh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_chinhanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tinhtrang" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tinhtrang" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_tinhtrang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tinhtrang" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_id" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[dmkhachhang] ([ma], [ten], [mataikhoan], [diachi], [maduong], [maphuong], [maquan], [phanloai], [loaikh], [ghichu], [manhomkh], [machinhanh], [dienthoai], [masothue], [tentat], [matinh], [tenkhuynhiemchi], [daidien1], [chucvu1], [dienthoai1], [daidien2], [chucvu2], [dienthoai2], [maquocgia], [makhuvuc], [makhcaptren], [hanmuctindung], [hanthanhtoan], [loaihinhkd], [ngayphatsinhgd], [ngaythanhlap], [nganhnghekd], [fax], [macu], [banggia], [chietkhau], [giamgia], [diachigiaohang], [loaivitri], [loaietc], [chinhanh], [tinhtrang]) VALUES (@ma, @ten, @mataikhoan, @diachi, @maduong, @maphuong, @maquan, @phanloai, @loaikh, @ghichu, @manhomkh, @machinhanh, @dienthoai, @masothue, @tentat, @matinh, @tenkhuynhiemchi, @daidien1, @chucvu1, @dienthoai1, @daidien2, @chucvu2, @dienthoai2, @maquocgia, @makhuvuc, @makhcaptren, @hanmuctindung, @hanthanhtoan, @loaihinhkd, @ngayphatsinhgd, @ngaythanhlap, @nganhnghekd, @fax, @macu, @banggia, @chietkhau, @giamgia, @diachigiaohang, @loaivitri, @loaietc, @chinhanh, @tinhtrang);
SELECT ma, ten, mataikhoan, diachi, maduong, maphuong, maquan, phanloai, loaikh, ghichu, manhomkh, machinhanh, dienthoai, masothue, tentat, matinh, tenkhuynhiemchi, daidien1, chucvu1, dienthoai1, daidien2, chucvu2, dienthoai2, maquocgia, makhuvuc, makhcaptren, hanmuctindung, hanthanhtoan, loaihinhkd, ngayphatsinhgd, ngaythanhlap, nganhnghekd, fax, macu, banggia, chietkhau, giamgia, diachigiaohang, loaivitri, loaietc, chinhanh, tinhtrang, id FROM dmkhachhang WHERE (id = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ten" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@mataikhoan" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="mataikhoan" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@diachi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="diachi" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@maduong" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="maduong" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@maphuong" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="maphuong" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@maquan" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="maquan" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@phanloai" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="phanloai" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@loaikh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loaikh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ghichu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ghichu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@manhomkh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="manhomkh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@machinhanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="machinhanh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@dienthoai" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="dienthoai" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@masothue" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="masothue" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@tentat" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tentat" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@matinh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="matinh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@tenkhuynhiemchi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tenkhuynhiemchi" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@daidien1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="daidien1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@chucvu1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chucvu1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@dienthoai1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="dienthoai1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@daidien2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="daidien2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@chucvu2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chucvu2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@dienthoai2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="dienthoai2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@maquocgia" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="maquocgia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@makhuvuc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="makhuvuc" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@makhcaptren" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="makhcaptren" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@hanmuctindung" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="hanmuctindung" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@hanthanhtoan" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="hanthanhtoan" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@loaihinhkd" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loaihinhkd" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ngayphatsinhgd" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngayphatsinhgd" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ngaythanhlap" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngaythanhlap" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@nganhnghekd" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nganhnghekd" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@fax" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="fax" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@macu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="macu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@banggia" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="banggia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@chietkhau" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="chietkhau" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@giamgia" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="giamgia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@diachigiaohang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="diachigiaohang" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@loaivitri" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loaivitri" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@loaietc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loaietc" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@chinhanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@tinhtrang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tinhtrang" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ma, ten, mataikhoan, diachi, maduong, maphuong, maquan, phanloai, loaikh, ghichu, manhomkh, machinhanh, dienthoai, masothue, tentat, matinh, tenkhuynhiemchi, daidien1, chucvu1, dienthoai1, daidien2, chucvu2, dienthoai2, maquocgia, makhuvuc, makhcaptren, hanmuctindung, hanthanhtoan, loaihinhkd, ngayphatsinhgd, ngaythanhlap, nganhnghekd, fax, macu, banggia, chietkhau, giamgia, diachigiaohang, loaivitri, loaietc, chinhanh, tinhtrang, id FROM dbo.dmkhachhang</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[dmkhachhang] SET [ma] = @ma, [ten] = @ten, [mataikhoan] = @mataikhoan, [diachi] = @diachi, [maduong] = @maduong, [maphuong] = @maphuong, [maquan] = @maquan, [phanloai] = @phanloai, [loaikh] = @loaikh, [ghichu] = @ghichu, [manhomkh] = @manhomkh, [machinhanh] = @machinhanh, [dienthoai] = @dienthoai, [masothue] = @masothue, [tentat] = @tentat, [matinh] = @matinh, [tenkhuynhiemchi] = @tenkhuynhiemchi, [daidien1] = @daidien1, [chucvu1] = @chucvu1, [dienthoai1] = @dienthoai1, [daidien2] = @daidien2, [chucvu2] = @chucvu2, [dienthoai2] = @dienthoai2, [maquocgia] = @maquocgia, [makhuvuc] = @makhuvuc, [makhcaptren] = @makhcaptren, [hanmuctindung] = @hanmuctindung, [hanthanhtoan] = @hanthanhtoan, [loaihinhkd] = @loaihinhkd, [ngayphatsinhgd] = @ngayphatsinhgd, [ngaythanhlap] = @ngaythanhlap, [nganhnghekd] = @nganhnghekd, [fax] = @fax, [macu] = @macu, [banggia] = @banggia, [chietkhau] = @chietkhau, [giamgia] = @giamgia, [diachigiaohang] = @diachigiaohang, [loaivitri] = @loaivitri, [loaietc] = @loaietc, [chinhanh] = @chinhanh, [tinhtrang] = @tinhtrang WHERE (([ma] = @Original_ma) AND ([ten] = @Original_ten) AND ((@IsNull_mataikhoan = 1 AND [mataikhoan] IS NULL) OR ([mataikhoan] = @Original_mataikhoan)) AND ((@IsNull_diachi = 1 AND [diachi] IS NULL) OR ([diachi] = @Original_diachi)) AND ((@IsNull_maduong = 1 AND [maduong] IS NULL) OR ([maduong] = @Original_maduong)) AND ((@IsNull_maphuong = 1 AND [maphuong] IS NULL) OR ([maphuong] = @Original_maphuong)) AND ((@IsNull_maquan = 1 AND [maquan] IS NULL) OR ([maquan] = @Original_maquan)) AND ((@IsNull_phanloai = 1 AND [phanloai] IS NULL) OR ([phanloai] = @Original_phanloai)) AND ((@IsNull_loaikh = 1 AND [loaikh] IS NULL) OR ([loaikh] = @Original_loaikh)) AND ((@IsNull_ghichu = 1 AND [ghichu] IS NULL) OR ([ghichu] = @Original_ghichu)) AND ((@IsNull_manhomkh = 1 AND [manhomkh] IS NULL) OR ([manhomkh] = @Original_manhomkh)) AND ((@IsNull_machinhanh = 1 AND [machinhanh] IS NULL) OR ([machinhanh] = @Original_machinhanh)) AND ((@IsNull_dienthoai = 1 AND [dienthoai] IS NULL) OR ([dienthoai] = @Original_dienthoai)) AND ((@IsNull_masothue = 1 AND [masothue] IS NULL) OR ([masothue] = @Original_masothue)) AND ((@IsNull_tentat = 1 AND [tentat] IS NULL) OR ([tentat] = @Original_tentat)) AND ((@IsNull_matinh = 1 AND [matinh] IS NULL) OR ([matinh] = @Original_matinh)) AND ((@IsNull_tenkhuynhiemchi = 1 AND [tenkhuynhiemchi] IS NULL) OR ([tenkhuynhiemchi] = @Original_tenkhuynhiemchi)) AND ((@IsNull_daidien1 = 1 AND [daidien1] IS NULL) OR ([daidien1] = @Original_daidien1)) AND ((@IsNull_chucvu1 = 1 AND [chucvu1] IS NULL) OR ([chucvu1] = @Original_chucvu1)) AND ((@IsNull_dienthoai1 = 1 AND [dienthoai1] IS NULL) OR ([dienthoai1] = @Original_dienthoai1)) AND ((@IsNull_daidien2 = 1 AND [daidien2] IS NULL) OR ([daidien2] = @Original_daidien2)) AND ((@IsNull_chucvu2 = 1 AND [chucvu2] IS NULL) OR ([chucvu2] = @Original_chucvu2)) AND ((@IsNull_dienthoai2 = 1 AND [dienthoai2] IS NULL) OR ([dienthoai2] = @Original_dienthoai2)) AND ((@IsNull_maquocgia = 1 AND [maquocgia] IS NULL) OR ([maquocgia] = @Original_maquocgia)) AND ((@IsNull_makhuvuc = 1 AND [makhuvuc] IS NULL) OR ([makhuvuc] = @Original_makhuvuc)) AND ((@IsNull_makhcaptren = 1 AND [makhcaptren] IS NULL) OR ([makhcaptren] = @Original_makhcaptren)) AND ((@IsNull_hanmuctindung = 1 AND [hanmuctindung] IS NULL) OR ([hanmuctindung] = @Original_hanmuctindung)) AND ((@IsNull_hanthanhtoan = 1 AND [hanthanhtoan] IS NULL) OR ([hanthanhtoan] = @Original_hanthanhtoan)) AND ((@IsNull_loaihinhkd = 1 AND [loaihinhkd] IS NULL) OR ([loaihinhkd] = @Original_loaihinhkd)) AND ((@IsNull_ngayphatsinhgd = 1 AND [ngayphatsinhgd] IS NULL) OR ([ngayphatsinhgd] = @Original_ngayphatsinhgd)) AND ((@IsNull_ngaythanhlap = 1 AND [ngaythanhlap] IS NULL) OR ([ngaythanhlap] = @Original_ngaythanhlap)) AND ((@IsNull_nganhnghekd = 1 AND [nganhnghekd] IS NULL) OR ([nganhnghekd] = @Original_nganhnghekd)) AND ((@IsNull_fax = 1 AND [fax] IS NULL) OR ([fax] = @Original_fax)) AND ((@IsNull_macu = 1 AND [macu] IS NULL) OR ([macu] = @Original_macu)) AND ((@IsNull_banggia = 1 AND [banggia] IS NULL) OR ([banggia] = @Original_banggia)) AND ((@IsNull_chietkhau = 1 AND [chietkhau] IS NULL) OR ([chietkhau] = @Original_chietkhau)) AND ((@IsNull_giamgia = 1 AND [giamgia] IS NULL) OR ([giamgia] = @Original_giamgia)) AND ((@IsNull_diachigiaohang = 1 AND [diachigiaohang] IS NULL) OR ([diachigiaohang] = @Original_diachigiaohang)) AND ((@IsNull_loaivitri = 1 AND [loaivitri] IS NULL) OR ([loaivitri] = @Original_loaivitri)) AND ((@IsNull_loaietc = 1 AND [loaietc] IS NULL) OR ([loaietc] = @Original_loaietc)) AND ((@IsNull_chinhanh = 1 AND [chinhanh] IS NULL) OR ([chinhanh] = @Original_chinhanh)) AND ((@IsNull_tinhtrang = 1 AND [tinhtrang] IS NULL) OR ([tinhtrang] = @Original_tinhtrang)) AND ([id] = @Original_id));
SELECT ma, ten, mataikhoan, diachi, maduong, maphuong, maquan, phanloai, loaikh, ghichu, manhomkh, machinhanh, dienthoai, masothue, tentat, matinh, tenkhuynhiemchi, daidien1, chucvu1, dienthoai1, daidien2, chucvu2, dienthoai2, maquocgia, makhuvuc, makhcaptren, hanmuctindung, hanthanhtoan, loaihinhkd, ngayphatsinhgd, ngaythanhlap, nganhnghekd, fax, macu, banggia, chietkhau, giamgia, diachigiaohang, loaivitri, loaietc, chinhanh, tinhtrang, id FROM dmkhachhang WHERE (id = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ten" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@mataikhoan" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="mataikhoan" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@diachi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="diachi" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@maduong" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="maduong" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@maphuong" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="maphuong" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@maquan" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="maquan" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@phanloai" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="phanloai" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@loaikh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loaikh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ghichu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ghichu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@manhomkh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="manhomkh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@machinhanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="machinhanh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@dienthoai" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="dienthoai" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@masothue" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="masothue" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@tentat" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tentat" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@matinh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="matinh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@tenkhuynhiemchi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tenkhuynhiemchi" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@daidien1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="daidien1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@chucvu1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chucvu1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@dienthoai1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="dienthoai1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@daidien2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="daidien2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@chucvu2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chucvu2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@dienthoai2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="dienthoai2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@maquocgia" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="maquocgia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@makhuvuc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="makhuvuc" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@makhcaptren" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="makhcaptren" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@hanmuctindung" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="hanmuctindung" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@hanthanhtoan" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="hanthanhtoan" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@loaihinhkd" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loaihinhkd" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ngayphatsinhgd" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngayphatsinhgd" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ngaythanhlap" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngaythanhlap" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@nganhnghekd" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nganhnghekd" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@fax" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="fax" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@macu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="macu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@banggia" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="banggia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@chietkhau" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="chietkhau" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@giamgia" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="giamgia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@diachigiaohang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="diachigiaohang" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@loaivitri" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loaivitri" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@loaietc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loaietc" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@chinhanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@tinhtrang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tinhtrang" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ten" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_mataikhoan" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="mataikhoan" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_mataikhoan" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="mataikhoan" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_diachi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="diachi" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_diachi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="diachi" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_maduong" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="maduong" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_maduong" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="maduong" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_maphuong" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="maphuong" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_maphuong" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="maphuong" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_maquan" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="maquan" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_maquan" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="maquan" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_phanloai" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="phanloai" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_phanloai" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="phanloai" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_loaikh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loaikh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_loaikh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loaikh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ghichu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ghichu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ghichu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ghichu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_manhomkh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="manhomkh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_manhomkh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="manhomkh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_machinhanh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="machinhanh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_machinhanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="machinhanh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dienthoai" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dienthoai" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_dienthoai" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="dienthoai" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_masothue" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="masothue" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_masothue" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="masothue" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tentat" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tentat" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_tentat" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tentat" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_matinh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="matinh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_matinh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="matinh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tenkhuynhiemchi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tenkhuynhiemchi" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_tenkhuynhiemchi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tenkhuynhiemchi" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_daidien1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="daidien1" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_daidien1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="daidien1" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_chucvu1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="chucvu1" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_chucvu1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chucvu1" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dienthoai1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dienthoai1" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_dienthoai1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="dienthoai1" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_daidien2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="daidien2" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_daidien2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="daidien2" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_chucvu2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="chucvu2" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_chucvu2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chucvu2" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dienthoai2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dienthoai2" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_dienthoai2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="dienthoai2" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_maquocgia" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="maquocgia" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_maquocgia" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="maquocgia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_makhuvuc" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="makhuvuc" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_makhuvuc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="makhuvuc" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_makhcaptren" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="makhcaptren" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_makhcaptren" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="makhcaptren" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_hanmuctindung" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="hanmuctindung" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_hanmuctindung" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="hanmuctindung" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_hanthanhtoan" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="hanthanhtoan" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_hanthanhtoan" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="hanthanhtoan" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_loaihinhkd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loaihinhkd" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_loaihinhkd" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loaihinhkd" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ngayphatsinhgd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ngayphatsinhgd" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ngayphatsinhgd" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngayphatsinhgd" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ngaythanhlap" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ngaythanhlap" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ngaythanhlap" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngaythanhlap" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nganhnghekd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nganhnghekd" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_nganhnghekd" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nganhnghekd" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fax" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fax" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_fax" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="fax" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_macu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="macu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_macu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="macu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_banggia" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="banggia" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_banggia" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="banggia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_chietkhau" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="chietkhau" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_chietkhau" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="chietkhau" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_giamgia" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="giamgia" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_giamgia" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="giamgia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_diachigiaohang" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="diachigiaohang" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_diachigiaohang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="diachigiaohang" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_loaivitri" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loaivitri" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_loaivitri" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loaivitri" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_loaietc" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loaietc" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_loaietc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loaietc" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_chinhanh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_chinhanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tinhtrang" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tinhtrang" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_tinhtrang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tinhtrang" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_id" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="id" ColumnName="id" DataSourceName="erpharma.dbo.dmkhachhang" DataTypeServer="numeric" DbType="Decimal" Direction="Input" ParameterName="@id" Precision="18" ProviderType="Decimal" Scale="0" Size="9" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ma" DataSetColumn="ma" />
              <Mapping SourceColumn="ten" DataSetColumn="ten" />
              <Mapping SourceColumn="mataikhoan" DataSetColumn="mataikhoan" />
              <Mapping SourceColumn="diachi" DataSetColumn="diachi" />
              <Mapping SourceColumn="maduong" DataSetColumn="maduong" />
              <Mapping SourceColumn="maphuong" DataSetColumn="maphuong" />
              <Mapping SourceColumn="maquan" DataSetColumn="maquan" />
              <Mapping SourceColumn="phanloai" DataSetColumn="phanloai" />
              <Mapping SourceColumn="loaikh" DataSetColumn="loaikh" />
              <Mapping SourceColumn="ghichu" DataSetColumn="ghichu" />
              <Mapping SourceColumn="manhomkh" DataSetColumn="manhomkh" />
              <Mapping SourceColumn="machinhanh" DataSetColumn="machinhanh" />
              <Mapping SourceColumn="dienthoai" DataSetColumn="dienthoai" />
              <Mapping SourceColumn="masothue" DataSetColumn="masothue" />
              <Mapping SourceColumn="tentat" DataSetColumn="tentat" />
              <Mapping SourceColumn="matinh" DataSetColumn="matinh" />
              <Mapping SourceColumn="tenkhuynhiemchi" DataSetColumn="tenkhuynhiemchi" />
              <Mapping SourceColumn="daidien1" DataSetColumn="daidien1" />
              <Mapping SourceColumn="chucvu1" DataSetColumn="chucvu1" />
              <Mapping SourceColumn="dienthoai1" DataSetColumn="dienthoai1" />
              <Mapping SourceColumn="daidien2" DataSetColumn="daidien2" />
              <Mapping SourceColumn="chucvu2" DataSetColumn="chucvu2" />
              <Mapping SourceColumn="dienthoai2" DataSetColumn="dienthoai2" />
              <Mapping SourceColumn="maquocgia" DataSetColumn="maquocgia" />
              <Mapping SourceColumn="makhuvuc" DataSetColumn="makhuvuc" />
              <Mapping SourceColumn="makhcaptren" DataSetColumn="makhcaptren" />
              <Mapping SourceColumn="hanmuctindung" DataSetColumn="hanmuctindung" />
              <Mapping SourceColumn="hanthanhtoan" DataSetColumn="hanthanhtoan" />
              <Mapping SourceColumn="loaihinhkd" DataSetColumn="loaihinhkd" />
              <Mapping SourceColumn="ngayphatsinhgd" DataSetColumn="ngayphatsinhgd" />
              <Mapping SourceColumn="ngaythanhlap" DataSetColumn="ngaythanhlap" />
              <Mapping SourceColumn="nganhnghekd" DataSetColumn="nganhnghekd" />
              <Mapping SourceColumn="fax" DataSetColumn="fax" />
              <Mapping SourceColumn="macu" DataSetColumn="macu" />
              <Mapping SourceColumn="banggia" DataSetColumn="banggia" />
              <Mapping SourceColumn="chietkhau" DataSetColumn="chietkhau" />
              <Mapping SourceColumn="giamgia" DataSetColumn="giamgia" />
              <Mapping SourceColumn="diachigiaohang" DataSetColumn="diachigiaohang" />
              <Mapping SourceColumn="loaivitri" DataSetColumn="loaivitri" />
              <Mapping SourceColumn="loaietc" DataSetColumn="loaietc" />
              <Mapping SourceColumn="chinhanh" DataSetColumn="chinhanh" />
              <Mapping SourceColumn="tinhtrang" DataSetColumn="tinhtrang" />
              <Mapping SourceColumn="id" DataSetColumn="id" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ketoantienmatTableAdapter" GeneratorDataComponentClassName="ketoantienmatTableAdapter" Name="ketoantienmat" UserDataComponentName="ketoantienmatTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="erpharmaConnectionString (MySettings)" DbObjectName="erpharma.dbo.ketoantienmat" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[ketoantienmat] WHERE (([ma] = @Original_ma) AND ((@IsNull_nghiepvu = 1 AND [nghiepvu] IS NULL) OR ([nghiepvu] = @Original_nghiepvu)) AND ((@IsNull_sochungtu = 1 AND [sochungtu] IS NULL) OR ([sochungtu] = @Original_sochungtu)) AND ((@IsNull_ngaylap = 1 AND [ngaylap] IS NULL) OR ([ngaylap] = @Original_ngaylap)) AND ((@IsNull_hoten = 1 AND [hoten] IS NULL) OR ([hoten] = @Original_hoten)) AND ((@IsNull_bophan = 1 AND [bophan] IS NULL) OR ([bophan] = @Original_bophan)) AND ((@IsNull_donvi = 1 AND [donvi] IS NULL) OR ([donvi] = @Original_donvi)) AND ((@IsNull_noidung = 1 AND [noidung] IS NULL) OR ([noidung] = @Original_noidung)) AND ((@IsNull_thamchieu = 1 AND [thamchieu] IS NULL) OR ([thamchieu] = @Original_thamchieu)) AND ((@IsNull_ngaylapthamchieu = 1 AND [ngaylapthamchieu] IS NULL) OR ([ngaylapthamchieu] = @Original_ngaylapthamchieu)) AND ((@IsNull_chungtukem = 1 AND [chungtukem] IS NULL) OR ([chungtukem] = @Original_chungtukem)) AND ((@IsNull_loaitien = 1 AND [loaitien] IS NULL) OR ([loaitien] = @Original_loaitien)) AND ([tygia] = @Original_tygia) AND ((@IsNull_nguyente = 1 AND [nguyente] IS NULL) OR ([nguyente] = @Original_nguyente)) AND ([tienvnd] = @Original_tienvnd) AND ((@IsNull_tinhtrang = 1 AND [tinhtrang] IS NULL) OR ([tinhtrang] = @Original_tinhtrang)) AND ((@IsNull_chinhanh = 1 AND [chinhanh] IS NULL) OR ([chinhanh] = @Original_chinhanh)) AND ([id] = @Original_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nghiepvu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nghiepvu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_nghiepvu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nghiepvu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_sochungtu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="sochungtu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_sochungtu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="sochungtu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ngaylap" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ngaylap" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ngaylap" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngaylap" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_hoten" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="hoten" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_hoten" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="hoten" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_bophan" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="bophan" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_bophan" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="bophan" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_donvi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="donvi" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_donvi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="donvi" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_noidung" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="noidung" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_noidung" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="noidung" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_thamchieu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="thamchieu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_thamchieu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="thamchieu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ngaylapthamchieu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ngaylapthamchieu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ngaylapthamchieu" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngaylapthamchieu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_chungtukem" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="chungtukem" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_chungtukem" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chungtukem" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_loaitien" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loaitien" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_loaitien" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loaitien" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_tygia" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="tygia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nguyente" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nguyente" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_nguyente" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="nguyente" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_tienvnd" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="tienvnd" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tinhtrang" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tinhtrang" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_tinhtrang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tinhtrang" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_chinhanh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_chinhanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_id" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[ketoantienmat] ([ma], [nghiepvu], [sochungtu], [ngaylap], [hoten], [bophan], [donvi], [noidung], [thamchieu], [ngaylapthamchieu], [chungtukem], [loaitien], [tygia], [nguyente], [tienvnd], [tinhtrang], [chinhanh]) VALUES (@ma, @nghiepvu, @sochungtu, @ngaylap, @hoten, @bophan, @donvi, @noidung, @thamchieu, @ngaylapthamchieu, @chungtukem, @loaitien, @tygia, @nguyente, @tienvnd, @tinhtrang, @chinhanh);
SELECT ma, nghiepvu, sochungtu, ngaylap, hoten, bophan, donvi, noidung, thamchieu, ngaylapthamchieu, chungtukem, loaitien, tygia, nguyente, tienvnd, tinhtrang, chinhanh, id FROM ketoantienmat WHERE (id = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@nghiepvu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nghiepvu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@sochungtu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="sochungtu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ngaylap" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngaylap" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@hoten" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="hoten" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@bophan" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="bophan" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@donvi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="donvi" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@noidung" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="noidung" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@thamchieu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="thamchieu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ngaylapthamchieu" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngaylapthamchieu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@chungtukem" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chungtukem" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@loaitien" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loaitien" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@tygia" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="tygia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@nguyente" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="nguyente" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@tienvnd" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="tienvnd" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@tinhtrang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tinhtrang" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@chinhanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ma, nghiepvu, sochungtu, ngaylap, hoten, bophan, donvi, noidung, thamchieu, ngaylapthamchieu, chungtukem, loaitien, tygia, nguyente, tienvnd, tinhtrang, chinhanh, id FROM dbo.ketoantienmat</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[ketoantienmat] SET [ma] = @ma, [nghiepvu] = @nghiepvu, [sochungtu] = @sochungtu, [ngaylap] = @ngaylap, [hoten] = @hoten, [bophan] = @bophan, [donvi] = @donvi, [noidung] = @noidung, [thamchieu] = @thamchieu, [ngaylapthamchieu] = @ngaylapthamchieu, [chungtukem] = @chungtukem, [loaitien] = @loaitien, [tygia] = @tygia, [nguyente] = @nguyente, [tienvnd] = @tienvnd, [tinhtrang] = @tinhtrang, [chinhanh] = @chinhanh WHERE (([ma] = @Original_ma) AND ((@IsNull_nghiepvu = 1 AND [nghiepvu] IS NULL) OR ([nghiepvu] = @Original_nghiepvu)) AND ((@IsNull_sochungtu = 1 AND [sochungtu] IS NULL) OR ([sochungtu] = @Original_sochungtu)) AND ((@IsNull_ngaylap = 1 AND [ngaylap] IS NULL) OR ([ngaylap] = @Original_ngaylap)) AND ((@IsNull_hoten = 1 AND [hoten] IS NULL) OR ([hoten] = @Original_hoten)) AND ((@IsNull_bophan = 1 AND [bophan] IS NULL) OR ([bophan] = @Original_bophan)) AND ((@IsNull_donvi = 1 AND [donvi] IS NULL) OR ([donvi] = @Original_donvi)) AND ((@IsNull_noidung = 1 AND [noidung] IS NULL) OR ([noidung] = @Original_noidung)) AND ((@IsNull_thamchieu = 1 AND [thamchieu] IS NULL) OR ([thamchieu] = @Original_thamchieu)) AND ((@IsNull_ngaylapthamchieu = 1 AND [ngaylapthamchieu] IS NULL) OR ([ngaylapthamchieu] = @Original_ngaylapthamchieu)) AND ((@IsNull_chungtukem = 1 AND [chungtukem] IS NULL) OR ([chungtukem] = @Original_chungtukem)) AND ((@IsNull_loaitien = 1 AND [loaitien] IS NULL) OR ([loaitien] = @Original_loaitien)) AND ([tygia] = @Original_tygia) AND ((@IsNull_nguyente = 1 AND [nguyente] IS NULL) OR ([nguyente] = @Original_nguyente)) AND ([tienvnd] = @Original_tienvnd) AND ((@IsNull_tinhtrang = 1 AND [tinhtrang] IS NULL) OR ([tinhtrang] = @Original_tinhtrang)) AND ((@IsNull_chinhanh = 1 AND [chinhanh] IS NULL) OR ([chinhanh] = @Original_chinhanh)) AND ([id] = @Original_id));
SELECT ma, nghiepvu, sochungtu, ngaylap, hoten, bophan, donvi, noidung, thamchieu, ngaylapthamchieu, chungtukem, loaitien, tygia, nguyente, tienvnd, tinhtrang, chinhanh, id FROM ketoantienmat WHERE (id = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@nghiepvu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nghiepvu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@sochungtu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="sochungtu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ngaylap" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngaylap" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@hoten" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="hoten" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@bophan" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="bophan" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@donvi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="donvi" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@noidung" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="noidung" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@thamchieu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="thamchieu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ngaylapthamchieu" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngaylapthamchieu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@chungtukem" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chungtukem" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@loaitien" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loaitien" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@tygia" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="tygia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@nguyente" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="nguyente" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@tienvnd" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="tienvnd" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@tinhtrang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tinhtrang" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@chinhanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nghiepvu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nghiepvu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_nghiepvu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nghiepvu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_sochungtu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="sochungtu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_sochungtu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="sochungtu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ngaylap" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ngaylap" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ngaylap" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngaylap" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_hoten" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="hoten" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_hoten" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="hoten" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_bophan" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="bophan" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_bophan" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="bophan" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_donvi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="donvi" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_donvi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="donvi" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_noidung" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="noidung" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_noidung" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="noidung" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_thamchieu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="thamchieu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_thamchieu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="thamchieu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ngaylapthamchieu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ngaylapthamchieu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ngaylapthamchieu" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngaylapthamchieu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_chungtukem" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="chungtukem" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_chungtukem" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chungtukem" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_loaitien" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loaitien" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_loaitien" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loaitien" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_tygia" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="tygia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nguyente" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nguyente" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_nguyente" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="nguyente" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_tienvnd" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="tienvnd" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tinhtrang" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tinhtrang" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_tinhtrang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tinhtrang" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_chinhanh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_chinhanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_id" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="id" ColumnName="id" DataSourceName="erpharma.dbo.ketoantienmat" DataTypeServer="decimal" DbType="Decimal" Direction="Input" ParameterName="@id" Precision="18" ProviderType="Decimal" Scale="0" Size="9" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ma" DataSetColumn="ma" />
              <Mapping SourceColumn="nghiepvu" DataSetColumn="nghiepvu" />
              <Mapping SourceColumn="sochungtu" DataSetColumn="sochungtu" />
              <Mapping SourceColumn="ngaylap" DataSetColumn="ngaylap" />
              <Mapping SourceColumn="hoten" DataSetColumn="hoten" />
              <Mapping SourceColumn="bophan" DataSetColumn="bophan" />
              <Mapping SourceColumn="donvi" DataSetColumn="donvi" />
              <Mapping SourceColumn="noidung" DataSetColumn="noidung" />
              <Mapping SourceColumn="thamchieu" DataSetColumn="thamchieu" />
              <Mapping SourceColumn="ngaylapthamchieu" DataSetColumn="ngaylapthamchieu" />
              <Mapping SourceColumn="chungtukem" DataSetColumn="chungtukem" />
              <Mapping SourceColumn="loaitien" DataSetColumn="loaitien" />
              <Mapping SourceColumn="tygia" DataSetColumn="tygia" />
              <Mapping SourceColumn="nguyente" DataSetColumn="nguyente" />
              <Mapping SourceColumn="tienvnd" DataSetColumn="tienvnd" />
              <Mapping SourceColumn="tinhtrang" DataSetColumn="tinhtrang" />
              <Mapping SourceColumn="chinhanh" DataSetColumn="chinhanh" />
              <Mapping SourceColumn="id" DataSetColumn="id" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ketoantienmat_thongtinchinhTableAdapter" GeneratorDataComponentClassName="ketoantienmat_thongtinchinhTableAdapter" Name="ketoantienmat_thongtinchinh" UserDataComponentName="ketoantienmat_thongtinchinhTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="erpharmaConnectionString (MySettings)" DbObjectName="erpharma.dbo.ketoantienmat_thongtinchinh" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[ketoantienmat_thongtinchinh] WHERE (([ma] = @Original_ma) AND ((@IsNull_taikhoanno = 1 AND [taikhoanno] IS NULL) OR ([taikhoanno] = @Original_taikhoanno)) AND ((@IsNull_taikhoanco = 1 AND [taikhoanco] IS NULL) OR ([taikhoanco] = @Original_taikhoanco)) AND ((@IsNull_nguyente = 1 AND [nguyente] IS NULL) OR ([nguyente] = @Original_nguyente)) AND ((@IsNull_tienvnd = 1 AND [tienvnd] IS NULL) OR ([tienvnd] = @Original_tienvnd)) AND ((@IsNull_diengiai = 1 AND [diengiai] IS NULL) OR ([diengiai] = @Original_diengiai)) AND ((@IsNull_donvi = 1 AND [donvi] IS NULL) OR ([donvi] = @Original_donvi)) AND ((@IsNull_diachi = 1 AND [diachi] IS NULL) OR ([diachi] = @Original_diachi)) AND ((@IsNull_masothue = 1 AND [masothue] IS NULL) OR ([masothue] = @Original_masothue)) AND ((@IsNull_sohoadon = 1 AND [sohoadon] IS NULL) OR ([sohoadon] = @Original_sohoadon)) AND ((@IsNull_ngay = 1 AND [ngay] IS NULL) OR ([ngay] = @Original_ngay)) AND ((@IsNull_khoanmuc = 1 AND [khoanmuc] IS NULL) OR ([khoanmuc] = @Original_khoanmuc)) AND ((@IsNull_phongban = 1 AND [phongban] IS NULL) OR ([phongban] = @Original_phongban)) AND ((@IsNull_hangmuc = 1 AND [hangmuc] IS NULL) OR ([hangmuc] = @Original_hangmuc)) AND ((@IsNull_hopdong = 1 AND [hopdong] IS NULL) OR ([hopdong] = @Original_hopdong)) AND ((@IsNull_nguonvon = 1 AND [nguonvon] IS NULL) OR ([nguonvon] = @Original_nguonvon)) AND ([id] = @Original_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_taikhoanno" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="taikhoanno" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_taikhoanno" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="taikhoanno" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_taikhoanco" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="taikhoanco" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_taikhoanco" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="taikhoanco" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nguyente" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nguyente" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_nguyente" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="nguyente" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tienvnd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tienvnd" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_tienvnd" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="tienvnd" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_diengiai" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="diengiai" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_diengiai" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="diengiai" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_donvi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="donvi" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_donvi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="donvi" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_diachi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="diachi" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_diachi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="diachi" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_masothue" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="masothue" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_masothue" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="masothue" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_sohoadon" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="sohoadon" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_sohoadon" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="sohoadon" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ngay" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ngay" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ngay" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngay" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_khoanmuc" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="khoanmuc" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_khoanmuc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="khoanmuc" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_phongban" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="phongban" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_phongban" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="phongban" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_hangmuc" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="hangmuc" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_hangmuc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="hangmuc" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_hopdong" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="hopdong" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_hopdong" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="hopdong" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nguonvon" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nguonvon" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_nguonvon" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nguonvon" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_id" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[ketoantienmat_thongtinchinh] ([ma], [taikhoanno], [taikhoanco], [nguyente], [tienvnd], [diengiai], [donvi], [diachi], [masothue], [sohoadon], [ngay], [khoanmuc], [phongban], [hangmuc], [hopdong], [nguonvon]) VALUES (@ma, @taikhoanno, @taikhoanco, @nguyente, @tienvnd, @diengiai, @donvi, @diachi, @masothue, @sohoadon, @ngay, @khoanmuc, @phongban, @hangmuc, @hopdong, @nguonvon);
SELECT ma, taikhoanno, taikhoanco, nguyente, tienvnd, diengiai, donvi, diachi, masothue, sohoadon, ngay, khoanmuc, phongban, hangmuc, hopdong, nguonvon, id FROM ketoantienmat_thongtinchinh WHERE (id = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@taikhoanno" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="taikhoanno" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@taikhoanco" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="taikhoanco" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@nguyente" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="nguyente" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@tienvnd" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="tienvnd" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@diengiai" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="diengiai" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@donvi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="donvi" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@diachi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="diachi" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@masothue" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="masothue" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@sohoadon" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="sohoadon" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ngay" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngay" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@khoanmuc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="khoanmuc" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@phongban" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="phongban" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@hangmuc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="hangmuc" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@hopdong" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="hopdong" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@nguonvon" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nguonvon" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ma, taikhoanno, taikhoanco, nguyente, tienvnd, diengiai, donvi, diachi, masothue, sohoadon, ngay, khoanmuc, phongban, hangmuc, hopdong, nguonvon, id FROM dbo.ketoantienmat_thongtinchinh</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[ketoantienmat_thongtinchinh] SET [ma] = @ma, [taikhoanno] = @taikhoanno, [taikhoanco] = @taikhoanco, [nguyente] = @nguyente, [tienvnd] = @tienvnd, [diengiai] = @diengiai, [donvi] = @donvi, [diachi] = @diachi, [masothue] = @masothue, [sohoadon] = @sohoadon, [ngay] = @ngay, [khoanmuc] = @khoanmuc, [phongban] = @phongban, [hangmuc] = @hangmuc, [hopdong] = @hopdong, [nguonvon] = @nguonvon WHERE (([ma] = @Original_ma) AND ((@IsNull_taikhoanno = 1 AND [taikhoanno] IS NULL) OR ([taikhoanno] = @Original_taikhoanno)) AND ((@IsNull_taikhoanco = 1 AND [taikhoanco] IS NULL) OR ([taikhoanco] = @Original_taikhoanco)) AND ((@IsNull_nguyente = 1 AND [nguyente] IS NULL) OR ([nguyente] = @Original_nguyente)) AND ((@IsNull_tienvnd = 1 AND [tienvnd] IS NULL) OR ([tienvnd] = @Original_tienvnd)) AND ((@IsNull_diengiai = 1 AND [diengiai] IS NULL) OR ([diengiai] = @Original_diengiai)) AND ((@IsNull_donvi = 1 AND [donvi] IS NULL) OR ([donvi] = @Original_donvi)) AND ((@IsNull_diachi = 1 AND [diachi] IS NULL) OR ([diachi] = @Original_diachi)) AND ((@IsNull_masothue = 1 AND [masothue] IS NULL) OR ([masothue] = @Original_masothue)) AND ((@IsNull_sohoadon = 1 AND [sohoadon] IS NULL) OR ([sohoadon] = @Original_sohoadon)) AND ((@IsNull_ngay = 1 AND [ngay] IS NULL) OR ([ngay] = @Original_ngay)) AND ((@IsNull_khoanmuc = 1 AND [khoanmuc] IS NULL) OR ([khoanmuc] = @Original_khoanmuc)) AND ((@IsNull_phongban = 1 AND [phongban] IS NULL) OR ([phongban] = @Original_phongban)) AND ((@IsNull_hangmuc = 1 AND [hangmuc] IS NULL) OR ([hangmuc] = @Original_hangmuc)) AND ((@IsNull_hopdong = 1 AND [hopdong] IS NULL) OR ([hopdong] = @Original_hopdong)) AND ((@IsNull_nguonvon = 1 AND [nguonvon] IS NULL) OR ([nguonvon] = @Original_nguonvon)) AND ([id] = @Original_id));
SELECT ma, taikhoanno, taikhoanco, nguyente, tienvnd, diengiai, donvi, diachi, masothue, sohoadon, ngay, khoanmuc, phongban, hangmuc, hopdong, nguonvon, id FROM ketoantienmat_thongtinchinh WHERE (id = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@taikhoanno" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="taikhoanno" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@taikhoanco" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="taikhoanco" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@nguyente" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="nguyente" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@tienvnd" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="tienvnd" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@diengiai" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="diengiai" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@donvi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="donvi" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@diachi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="diachi" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@masothue" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="masothue" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@sohoadon" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="sohoadon" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ngay" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngay" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@khoanmuc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="khoanmuc" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@phongban" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="phongban" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@hangmuc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="hangmuc" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@hopdong" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="hopdong" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@nguonvon" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nguonvon" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_taikhoanno" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="taikhoanno" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_taikhoanno" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="taikhoanno" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_taikhoanco" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="taikhoanco" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_taikhoanco" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="taikhoanco" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nguyente" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nguyente" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_nguyente" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="nguyente" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tienvnd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tienvnd" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_tienvnd" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="tienvnd" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_diengiai" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="diengiai" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_diengiai" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="diengiai" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_donvi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="donvi" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_donvi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="donvi" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_diachi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="diachi" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_diachi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="diachi" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_masothue" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="masothue" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_masothue" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="masothue" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_sohoadon" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="sohoadon" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_sohoadon" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="sohoadon" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ngay" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ngay" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ngay" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngay" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_khoanmuc" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="khoanmuc" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_khoanmuc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="khoanmuc" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_phongban" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="phongban" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_phongban" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="phongban" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_hangmuc" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="hangmuc" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_hangmuc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="hangmuc" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_hopdong" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="hopdong" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_hopdong" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="hopdong" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nguonvon" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nguonvon" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_nguonvon" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nguonvon" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_id" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="id" ColumnName="id" DataSourceName="erpharma.dbo.ketoantienmat_thongtinchinh" DataTypeServer="decimal" DbType="Decimal" Direction="Input" ParameterName="@id" Precision="18" ProviderType="Decimal" Scale="0" Size="9" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ma" DataSetColumn="ma" />
              <Mapping SourceColumn="taikhoanno" DataSetColumn="taikhoanno" />
              <Mapping SourceColumn="taikhoanco" DataSetColumn="taikhoanco" />
              <Mapping SourceColumn="nguyente" DataSetColumn="nguyente" />
              <Mapping SourceColumn="tienvnd" DataSetColumn="tienvnd" />
              <Mapping SourceColumn="diengiai" DataSetColumn="diengiai" />
              <Mapping SourceColumn="donvi" DataSetColumn="donvi" />
              <Mapping SourceColumn="diachi" DataSetColumn="diachi" />
              <Mapping SourceColumn="masothue" DataSetColumn="masothue" />
              <Mapping SourceColumn="sohoadon" DataSetColumn="sohoadon" />
              <Mapping SourceColumn="ngay" DataSetColumn="ngay" />
              <Mapping SourceColumn="khoanmuc" DataSetColumn="khoanmuc" />
              <Mapping SourceColumn="phongban" DataSetColumn="phongban" />
              <Mapping SourceColumn="hangmuc" DataSetColumn="hangmuc" />
              <Mapping SourceColumn="hopdong" DataSetColumn="hopdong" />
              <Mapping SourceColumn="nguonvon" DataSetColumn="nguonvon" />
              <Mapping SourceColumn="id" DataSetColumn="id" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ketoantienmat_thongtinthueTableAdapter" GeneratorDataComponentClassName="ketoantienmat_thongtinthueTableAdapter" Name="ketoantienmat_thongtinthue" UserDataComponentName="ketoantienmat_thongtinthueTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="erpharmaConnectionString (MySettings)" DbObjectName="erpharma.dbo.ketoantienmat_thongtinthue" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[ketoantienmat_thongtinthue] WHERE (([ma] = @Original_ma) AND ((@IsNull_sohoadon = 1 AND [sohoadon] IS NULL) OR ([sohoadon] = @Original_sohoadon)) AND ((@IsNull_soserie = 1 AND [soserie] IS NULL) OR ([soserie] = @Original_soserie)) AND ((@IsNull_loaihoadon = 1 AND [loaihoadon] IS NULL) OR ([loaihoadon] = @Original_loaihoadon)) AND ((@IsNull_ngayhoadon = 1 AND [ngayhoadon] IS NULL) OR ([ngayhoadon] = @Original_ngayhoadon)) AND ((@IsNull_tenhang = 1 AND [tenhang] IS NULL) OR ([tenhang] = @Original_tenhang)) AND ((@IsNull_donvi = 1 AND [donvi] IS NULL) OR ([donvi] = @Original_donvi)) AND ((@IsNull_diachi = 1 AND [diachi] IS NULL) OR ([diachi] = @Original_diachi)) AND ((@IsNull_masothue = 1 AND [masothue] IS NULL) OR ([masothue] = @Original_masothue)) AND ((@IsNull_doanhthu = 1 AND [doanhthu] IS NULL) OR ([doanhthu] = @Original_doanhthu)) AND ((@IsNull_phantramthue = 1 AND [phantramthue] IS NULL) OR ([phantramthue] = @Original_phantramthue)) AND ((@IsNull_thue = 1 AND [thue] IS NULL) OR ([thue] = @Original_thue)) AND ((@IsNull_tongcong = 1 AND [tongcong] IS NULL) OR ([tongcong] = @Original_tongcong)) AND ((@IsNull_chinhanh = 1 AND [chinhanh] IS NULL) OR ([chinhanh] = @Original_chinhanh)) AND ([id] = @Original_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_sohoadon" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="sohoadon" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_sohoadon" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="sohoadon" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_soserie" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="soserie" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_soserie" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="soserie" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_loaihoadon" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loaihoadon" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_loaihoadon" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loaihoadon" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ngayhoadon" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ngayhoadon" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ngayhoadon" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngayhoadon" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tenhang" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tenhang" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_tenhang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tenhang" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_donvi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="donvi" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_donvi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="donvi" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_diachi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="diachi" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_diachi" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="diachi" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_masothue" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="masothue" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_masothue" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="masothue" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_doanhthu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="doanhthu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_doanhthu" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="doanhthu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_phantramthue" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="phantramthue" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_phantramthue" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="phantramthue" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_thue" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="thue" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_thue" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="thue" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tongcong" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tongcong" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_tongcong" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="tongcong" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_chinhanh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_chinhanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_id" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[ketoantienmat_thongtinthue] ([ma], [sohoadon], [soserie], [loaihoadon], [ngayhoadon], [tenhang], [donvi], [diachi], [masothue], [doanhthu], [phantramthue], [thue], [tongcong], [chinhanh]) VALUES (@ma, @sohoadon, @soserie, @loaihoadon, @ngayhoadon, @tenhang, @donvi, @diachi, @masothue, @doanhthu, @phantramthue, @thue, @tongcong, @chinhanh);
SELECT ma, sohoadon, soserie, loaihoadon, ngayhoadon, tenhang, donvi, diachi, masothue, doanhthu, phantramthue, thue, tongcong, chinhanh, id FROM ketoantienmat_thongtinthue WHERE (id = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@sohoadon" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="sohoadon" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@soserie" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="soserie" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@loaihoadon" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loaihoadon" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ngayhoadon" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngayhoadon" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@tenhang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tenhang" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@donvi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="donvi" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@diachi" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="diachi" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@masothue" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="masothue" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@doanhthu" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="doanhthu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@phantramthue" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="phantramthue" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@thue" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="thue" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@tongcong" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="tongcong" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@chinhanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ma, sohoadon, soserie, loaihoadon, ngayhoadon, tenhang, donvi, diachi, masothue, doanhthu, phantramthue, thue, tongcong, chinhanh, id FROM dbo.ketoantienmat_thongtinthue</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[ketoantienmat_thongtinthue] SET [ma] = @ma, [sohoadon] = @sohoadon, [soserie] = @soserie, [loaihoadon] = @loaihoadon, [ngayhoadon] = @ngayhoadon, [tenhang] = @tenhang, [donvi] = @donvi, [diachi] = @diachi, [masothue] = @masothue, [doanhthu] = @doanhthu, [phantramthue] = @phantramthue, [thue] = @thue, [tongcong] = @tongcong, [chinhanh] = @chinhanh WHERE (([ma] = @Original_ma) AND ((@IsNull_sohoadon = 1 AND [sohoadon] IS NULL) OR ([sohoadon] = @Original_sohoadon)) AND ((@IsNull_soserie = 1 AND [soserie] IS NULL) OR ([soserie] = @Original_soserie)) AND ((@IsNull_loaihoadon = 1 AND [loaihoadon] IS NULL) OR ([loaihoadon] = @Original_loaihoadon)) AND ((@IsNull_ngayhoadon = 1 AND [ngayhoadon] IS NULL) OR ([ngayhoadon] = @Original_ngayhoadon)) AND ((@IsNull_tenhang = 1 AND [tenhang] IS NULL) OR ([tenhang] = @Original_tenhang)) AND ((@IsNull_donvi = 1 AND [donvi] IS NULL) OR ([donvi] = @Original_donvi)) AND ((@IsNull_diachi = 1 AND [diachi] IS NULL) OR ([diachi] = @Original_diachi)) AND ((@IsNull_masothue = 1 AND [masothue] IS NULL) OR ([masothue] = @Original_masothue)) AND ((@IsNull_doanhthu = 1 AND [doanhthu] IS NULL) OR ([doanhthu] = @Original_doanhthu)) AND ((@IsNull_phantramthue = 1 AND [phantramthue] IS NULL) OR ([phantramthue] = @Original_phantramthue)) AND ((@IsNull_thue = 1 AND [thue] IS NULL) OR ([thue] = @Original_thue)) AND ((@IsNull_tongcong = 1 AND [tongcong] IS NULL) OR ([tongcong] = @Original_tongcong)) AND ((@IsNull_chinhanh = 1 AND [chinhanh] IS NULL) OR ([chinhanh] = @Original_chinhanh)) AND ([id] = @Original_id));
SELECT ma, sohoadon, soserie, loaihoadon, ngayhoadon, tenhang, donvi, diachi, masothue, doanhthu, phantramthue, thue, tongcong, chinhanh, id FROM ketoantienmat_thongtinthue WHERE (id = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@sohoadon" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="sohoadon" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@soserie" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="soserie" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@loaihoadon" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loaihoadon" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ngayhoadon" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngayhoadon" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@tenhang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tenhang" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@donvi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="donvi" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@diachi" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="diachi" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@masothue" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="masothue" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@doanhthu" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="doanhthu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@phantramthue" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="phantramthue" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@thue" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="thue" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@tongcong" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="tongcong" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@chinhanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_sohoadon" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="sohoadon" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_sohoadon" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="sohoadon" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_soserie" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="soserie" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_soserie" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="soserie" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_loaihoadon" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loaihoadon" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_loaihoadon" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loaihoadon" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ngayhoadon" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ngayhoadon" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ngayhoadon" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngayhoadon" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tenhang" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tenhang" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_tenhang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tenhang" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_donvi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="donvi" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_donvi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="donvi" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_diachi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="diachi" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_diachi" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="diachi" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_masothue" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="masothue" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_masothue" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="masothue" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_doanhthu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="doanhthu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_doanhthu" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="doanhthu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_phantramthue" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="phantramthue" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_phantramthue" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="phantramthue" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_thue" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="thue" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_thue" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="thue" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tongcong" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tongcong" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_tongcong" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="tongcong" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_chinhanh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_chinhanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_id" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="id" ColumnName="id" DataSourceName="erpharma.dbo.ketoantienmat_thongtinthue" DataTypeServer="decimal" DbType="Decimal" Direction="Input" ParameterName="@id" Precision="18" ProviderType="Decimal" Scale="0" Size="9" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ma" DataSetColumn="ma" />
              <Mapping SourceColumn="sohoadon" DataSetColumn="sohoadon" />
              <Mapping SourceColumn="soserie" DataSetColumn="soserie" />
              <Mapping SourceColumn="loaihoadon" DataSetColumn="loaihoadon" />
              <Mapping SourceColumn="ngayhoadon" DataSetColumn="ngayhoadon" />
              <Mapping SourceColumn="tenhang" DataSetColumn="tenhang" />
              <Mapping SourceColumn="donvi" DataSetColumn="donvi" />
              <Mapping SourceColumn="diachi" DataSetColumn="diachi" />
              <Mapping SourceColumn="masothue" DataSetColumn="masothue" />
              <Mapping SourceColumn="doanhthu" DataSetColumn="doanhthu" />
              <Mapping SourceColumn="phantramthue" DataSetColumn="phantramthue" />
              <Mapping SourceColumn="thue" DataSetColumn="thue" />
              <Mapping SourceColumn="tongcong" DataSetColumn="tongcong" />
              <Mapping SourceColumn="chinhanh" DataSetColumn="chinhanh" />
              <Mapping SourceColumn="id" DataSetColumn="id" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="dmnganhangTableAdapter" GeneratorDataComponentClassName="dmnganhangTableAdapter" Name="dmnganhang" UserDataComponentName="dmnganhangTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="erpharmaConnectionString (MySettings)" DbObjectName="erpharma.dbo.dmnganhang" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[dmnganhang] WHERE (([ma] = @Original_ma) AND ([ten] = @Original_ten) AND ((@IsNull_ghichu = 1 AND [ghichu] IS NULL) OR ([ghichu] = @Original_ghichu)) AND ((@IsNull_chinhanh = 1 AND [chinhanh] IS NULL) OR ([chinhanh] = @Original_chinhanh)) AND ([tinhtrang] = @Original_tinhtrang) AND ([id] = @Original_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ten" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ghichu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ghichu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ghichu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ghichu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_chinhanh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_chinhanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_tinhtrang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tinhtrang" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_id" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[dmnganhang] ([ma], [ten], [ghichu], [chinhanh], [tinhtrang]) VALUES (@ma, @ten, @ghichu, @chinhanh, @tinhtrang);
SELECT ma, ten, ghichu, chinhanh, tinhtrang, id FROM dmnganhang WHERE (id = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ten" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ghichu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ghichu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@chinhanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@tinhtrang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tinhtrang" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ma, ten, ghichu, chinhanh, tinhtrang, id FROM dbo.dmnganhang</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[dmnganhang] SET [ma] = @ma, [ten] = @ten, [ghichu] = @ghichu, [chinhanh] = @chinhanh, [tinhtrang] = @tinhtrang WHERE (([ma] = @Original_ma) AND ([ten] = @Original_ten) AND ((@IsNull_ghichu = 1 AND [ghichu] IS NULL) OR ([ghichu] = @Original_ghichu)) AND ((@IsNull_chinhanh = 1 AND [chinhanh] IS NULL) OR ([chinhanh] = @Original_chinhanh)) AND ([tinhtrang] = @Original_tinhtrang) AND ([id] = @Original_id));
SELECT ma, ten, ghichu, chinhanh, tinhtrang, id FROM dmnganhang WHERE (id = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ten" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ghichu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ghichu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@chinhanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@tinhtrang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tinhtrang" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ten" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ghichu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ghichu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ghichu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ghichu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_chinhanh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_chinhanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_tinhtrang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tinhtrang" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_id" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="id" ColumnName="id" DataSourceName="erpharma.dbo.dmnganhang" DataTypeServer="decimal" DbType="Decimal" Direction="Input" ParameterName="@id" Precision="18" ProviderType="Decimal" Scale="0" Size="9" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ma" DataSetColumn="ma" />
              <Mapping SourceColumn="ten" DataSetColumn="ten" />
              <Mapping SourceColumn="ghichu" DataSetColumn="ghichu" />
              <Mapping SourceColumn="chinhanh" DataSetColumn="chinhanh" />
              <Mapping SourceColumn="tinhtrang" DataSetColumn="tinhtrang" />
              <Mapping SourceColumn="id" DataSetColumn="id" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="dmtaikhoannganhangTableAdapter" GeneratorDataComponentClassName="dmtaikhoannganhangTableAdapter" Name="dmtaikhoannganhang" UserDataComponentName="dmtaikhoannganhangTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="erpharmaConnectionString (MySettings)" DbObjectName="erpharma.dbo.dmtaikhoannganhang" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[dmtaikhoannganhang] WHERE (([ma] = @Original_ma) AND ([manganhang] = @Original_manganhang) AND ([makhachhang] = @Original_makhachhang) AND ((@IsNull_noidung = 1 AND [noidung] IS NULL) OR ([noidung] = @Original_noidung)) AND ((@IsNull_taikhoankt = 1 AND [taikhoankt] IS NULL) OR ([taikhoankt] = @Original_taikhoankt)) AND ([matinh] = @Original_matinh) AND ((@IsNull_maloaitien = 1 AND [maloaitien] IS NULL) OR ([maloaitien] = @Original_maloaitien)) AND ((@IsNull_chinhanh = 1 AND [chinhanh] IS NULL) OR ([chinhanh] = @Original_chinhanh)) AND ([tinhtrang] = @Original_tinhtrang) AND ([id] = @Original_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_manganhang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="manganhang" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_makhachhang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="makhachhang" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_noidung" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="noidung" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_noidung" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="noidung" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_taikhoankt" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="taikhoankt" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_taikhoankt" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="taikhoankt" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_matinh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="matinh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_maloaitien" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="maloaitien" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_maloaitien" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="maloaitien" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_chinhanh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_chinhanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_tinhtrang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tinhtrang" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_id" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[dmtaikhoannganhang] ([ma], [manganhang], [makhachhang], [noidung], [taikhoankt], [matinh], [maloaitien], [chinhanh], [tinhtrang]) VALUES (@ma, @manganhang, @makhachhang, @noidung, @taikhoankt, @matinh, @maloaitien, @chinhanh, @tinhtrang);
SELECT ma, manganhang, makhachhang, noidung, taikhoankt, matinh, maloaitien, chinhanh, tinhtrang, id FROM dmtaikhoannganhang WHERE (id = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@manganhang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="manganhang" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@makhachhang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="makhachhang" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@noidung" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="noidung" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@taikhoankt" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="taikhoankt" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@matinh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="matinh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@maloaitien" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="maloaitien" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@chinhanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@tinhtrang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tinhtrang" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ma, manganhang, makhachhang, noidung, taikhoankt, matinh, maloaitien, chinhanh, tinhtrang, id FROM dbo.dmtaikhoannganhang</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[dmtaikhoannganhang] SET [ma] = @ma, [manganhang] = @manganhang, [makhachhang] = @makhachhang, [noidung] = @noidung, [taikhoankt] = @taikhoankt, [matinh] = @matinh, [maloaitien] = @maloaitien, [chinhanh] = @chinhanh, [tinhtrang] = @tinhtrang WHERE (([ma] = @Original_ma) AND ([manganhang] = @Original_manganhang) AND ([makhachhang] = @Original_makhachhang) AND ((@IsNull_noidung = 1 AND [noidung] IS NULL) OR ([noidung] = @Original_noidung)) AND ((@IsNull_taikhoankt = 1 AND [taikhoankt] IS NULL) OR ([taikhoankt] = @Original_taikhoankt)) AND ([matinh] = @Original_matinh) AND ((@IsNull_maloaitien = 1 AND [maloaitien] IS NULL) OR ([maloaitien] = @Original_maloaitien)) AND ((@IsNull_chinhanh = 1 AND [chinhanh] IS NULL) OR ([chinhanh] = @Original_chinhanh)) AND ([tinhtrang] = @Original_tinhtrang) AND ([id] = @Original_id));
SELECT ma, manganhang, makhachhang, noidung, taikhoankt, matinh, maloaitien, chinhanh, tinhtrang, id FROM dmtaikhoannganhang WHERE (id = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@manganhang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="manganhang" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@makhachhang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="makhachhang" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@noidung" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="noidung" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@taikhoankt" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="taikhoankt" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@matinh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="matinh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@maloaitien" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="maloaitien" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@chinhanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@tinhtrang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tinhtrang" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_manganhang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="manganhang" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_makhachhang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="makhachhang" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_noidung" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="noidung" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_noidung" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="noidung" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_taikhoankt" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="taikhoankt" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_taikhoankt" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="taikhoankt" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_matinh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="matinh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_maloaitien" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="maloaitien" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_maloaitien" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="maloaitien" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_chinhanh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_chinhanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_tinhtrang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tinhtrang" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_id" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="id" ColumnName="id" DataSourceName="erpharma.dbo.dmtaikhoannganhang" DataTypeServer="decimal" DbType="Decimal" Direction="Input" ParameterName="@id" Precision="18" ProviderType="Decimal" Scale="0" Size="9" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ma" DataSetColumn="ma" />
              <Mapping SourceColumn="manganhang" DataSetColumn="manganhang" />
              <Mapping SourceColumn="makhachhang" DataSetColumn="makhachhang" />
              <Mapping SourceColumn="noidung" DataSetColumn="noidung" />
              <Mapping SourceColumn="taikhoankt" DataSetColumn="taikhoankt" />
              <Mapping SourceColumn="matinh" DataSetColumn="matinh" />
              <Mapping SourceColumn="maloaitien" DataSetColumn="maloaitien" />
              <Mapping SourceColumn="chinhanh" DataSetColumn="chinhanh" />
              <Mapping SourceColumn="tinhtrang" DataSetColumn="tinhtrang" />
              <Mapping SourceColumn="id" DataSetColumn="id" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="donvisudungTableAdapter" GeneratorDataComponentClassName="donvisudungTableAdapter" Name="donvisudung" UserDataComponentName="donvisudungTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="erpharmaConnectionString (MySettings)" DbObjectName="erpharma.dbo.donvisudung" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[donvisudung] ([ten], [diachi], [logo], [dienthoai], [fax], [email]) VALUES (@ten, @diachi, @logo, @dienthoai, @fax, @email)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ten" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@diachi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="diachi" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@logo" Precision="0" ProviderType="Image" Scale="0" Size="0" SourceColumn="logo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@dienthoai" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="dienthoai" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@fax" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="fax" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@email" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="email" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ten, diachi, logo, dienthoai, fax, email FROM dbo.donvisudung</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ten" DataSetColumn="ten" />
              <Mapping SourceColumn="diachi" DataSetColumn="diachi" />
              <Mapping SourceColumn="logo" DataSetColumn="logo" />
              <Mapping SourceColumn="dienthoai" DataSetColumn="dienthoai" />
              <Mapping SourceColumn="fax" DataSetColumn="fax" />
              <Mapping SourceColumn="email" DataSetColumn="email" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="erpharmaDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="erpharmaDataSet" msprop:Generator_UserDSName="erpharmaDataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="dmkhachhang" msprop:Generator_TableClassName="dmkhachhangDataTable" msprop:Generator_TableVarName="tabledmkhachhang" msprop:Generator_TablePropName="dmkhachhang" msprop:Generator_RowDeletingName="dmkhachhangRowDeleting" msprop:Generator_UserTableName="dmkhachhang" msprop:Generator_RowChangingName="dmkhachhangRowChanging" msprop:Generator_RowEvHandlerName="dmkhachhangRowChangeEventHandler" msprop:Generator_RowDeletedName="dmkhachhangRowDeleted" msprop:Generator_RowEvArgName="dmkhachhangRowChangeEvent" msprop:Generator_RowChangedName="dmkhachhangRowChanged" msprop:Generator_RowClassName="dmkhachhangRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ma" msprop:Generator_ColumnVarNameInTable="columnma" msprop:Generator_ColumnPropNameInRow="ma" msprop:Generator_ColumnPropNameInTable="maColumn" msprop:Generator_UserColumnName="ma">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ten" msprop:Generator_ColumnVarNameInTable="columnten" msprop:Generator_ColumnPropNameInRow="ten" msprop:Generator_ColumnPropNameInTable="tenColumn" msprop:Generator_UserColumnName="ten">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="mataikhoan" msprop:Generator_ColumnVarNameInTable="columnmataikhoan" msprop:Generator_ColumnPropNameInRow="mataikhoan" msprop:Generator_ColumnPropNameInTable="mataikhoanColumn" msprop:Generator_UserColumnName="mataikhoan" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="diachi" msprop:Generator_ColumnVarNameInTable="columndiachi" msprop:Generator_ColumnPropNameInRow="diachi" msprop:Generator_ColumnPropNameInTable="diachiColumn" msprop:Generator_UserColumnName="diachi" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="maduong" msprop:Generator_ColumnVarNameInTable="columnmaduong" msprop:Generator_ColumnPropNameInRow="maduong" msprop:Generator_ColumnPropNameInTable="maduongColumn" msprop:Generator_UserColumnName="maduong" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="maphuong" msprop:Generator_ColumnVarNameInTable="columnmaphuong" msprop:Generator_ColumnPropNameInRow="maphuong" msprop:Generator_ColumnPropNameInTable="maphuongColumn" msprop:Generator_UserColumnName="maphuong" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="maquan" msprop:Generator_ColumnVarNameInTable="columnmaquan" msprop:Generator_ColumnPropNameInRow="maquan" msprop:Generator_ColumnPropNameInTable="maquanColumn" msprop:Generator_UserColumnName="maquan" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="phanloai" msprop:Generator_ColumnVarNameInTable="columnphanloai" msprop:Generator_ColumnPropNameInRow="phanloai" msprop:Generator_ColumnPropNameInTable="phanloaiColumn" msprop:Generator_UserColumnName="phanloai" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="loaikh" msprop:Generator_ColumnVarNameInTable="columnloaikh" msprop:Generator_ColumnPropNameInRow="loaikh" msprop:Generator_ColumnPropNameInTable="loaikhColumn" msprop:Generator_UserColumnName="loaikh" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ghichu" msprop:Generator_ColumnVarNameInTable="columnghichu" msprop:Generator_ColumnPropNameInRow="ghichu" msprop:Generator_ColumnPropNameInTable="ghichuColumn" msprop:Generator_UserColumnName="ghichu" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="manhomkh" msprop:Generator_ColumnVarNameInTable="columnmanhomkh" msprop:Generator_ColumnPropNameInRow="manhomkh" msprop:Generator_ColumnPropNameInTable="manhomkhColumn" msprop:Generator_UserColumnName="manhomkh" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="machinhanh" msprop:Generator_ColumnVarNameInTable="columnmachinhanh" msprop:Generator_ColumnPropNameInRow="machinhanh" msprop:Generator_ColumnPropNameInTable="machinhanhColumn" msprop:Generator_UserColumnName="machinhanh" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="dienthoai" msprop:Generator_ColumnVarNameInTable="columndienthoai" msprop:Generator_ColumnPropNameInRow="dienthoai" msprop:Generator_ColumnPropNameInTable="dienthoaiColumn" msprop:Generator_UserColumnName="dienthoai" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="masothue" msprop:Generator_ColumnVarNameInTable="columnmasothue" msprop:Generator_ColumnPropNameInRow="masothue" msprop:Generator_ColumnPropNameInTable="masothueColumn" msprop:Generator_UserColumnName="masothue" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="tentat" msprop:Generator_ColumnVarNameInTable="columntentat" msprop:Generator_ColumnPropNameInRow="tentat" msprop:Generator_ColumnPropNameInTable="tentatColumn" msprop:Generator_UserColumnName="tentat" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="matinh" msprop:Generator_ColumnVarNameInTable="columnmatinh" msprop:Generator_ColumnPropNameInRow="matinh" msprop:Generator_ColumnPropNameInTable="matinhColumn" msprop:Generator_UserColumnName="matinh" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="tenkhuynhiemchi" msprop:Generator_ColumnVarNameInTable="columntenkhuynhiemchi" msprop:Generator_ColumnPropNameInRow="tenkhuynhiemchi" msprop:Generator_ColumnPropNameInTable="tenkhuynhiemchiColumn" msprop:Generator_UserColumnName="tenkhuynhiemchi" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="daidien1" msprop:Generator_ColumnVarNameInTable="columndaidien1" msprop:Generator_ColumnPropNameInRow="daidien1" msprop:Generator_ColumnPropNameInTable="daidien1Column" msprop:Generator_UserColumnName="daidien1" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="chucvu1" msprop:Generator_ColumnVarNameInTable="columnchucvu1" msprop:Generator_ColumnPropNameInRow="chucvu1" msprop:Generator_ColumnPropNameInTable="chucvu1Column" msprop:Generator_UserColumnName="chucvu1" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="dienthoai1" msprop:Generator_ColumnVarNameInTable="columndienthoai1" msprop:Generator_ColumnPropNameInRow="dienthoai1" msprop:Generator_ColumnPropNameInTable="dienthoai1Column" msprop:Generator_UserColumnName="dienthoai1" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="daidien2" msprop:Generator_ColumnVarNameInTable="columndaidien2" msprop:Generator_ColumnPropNameInRow="daidien2" msprop:Generator_ColumnPropNameInTable="daidien2Column" msprop:Generator_UserColumnName="daidien2" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="chucvu2" msprop:Generator_ColumnVarNameInTable="columnchucvu2" msprop:Generator_ColumnPropNameInRow="chucvu2" msprop:Generator_ColumnPropNameInTable="chucvu2Column" msprop:Generator_UserColumnName="chucvu2" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="dienthoai2" msprop:Generator_ColumnVarNameInTable="columndienthoai2" msprop:Generator_ColumnPropNameInRow="dienthoai2" msprop:Generator_ColumnPropNameInTable="dienthoai2Column" msprop:Generator_UserColumnName="dienthoai2" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="maquocgia" msprop:Generator_ColumnVarNameInTable="columnmaquocgia" msprop:Generator_ColumnPropNameInRow="maquocgia" msprop:Generator_ColumnPropNameInTable="maquocgiaColumn" msprop:Generator_UserColumnName="maquocgia" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="makhuvuc" msprop:Generator_ColumnVarNameInTable="columnmakhuvuc" msprop:Generator_ColumnPropNameInRow="makhuvuc" msprop:Generator_ColumnPropNameInTable="makhuvucColumn" msprop:Generator_UserColumnName="makhuvuc" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="makhcaptren" msprop:Generator_ColumnVarNameInTable="columnmakhcaptren" msprop:Generator_ColumnPropNameInRow="makhcaptren" msprop:Generator_ColumnPropNameInTable="makhcaptrenColumn" msprop:Generator_UserColumnName="makhcaptren" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="hanmuctindung" msprop:Generator_ColumnVarNameInTable="columnhanmuctindung" msprop:Generator_ColumnPropNameInRow="hanmuctindung" msprop:Generator_ColumnPropNameInTable="hanmuctindungColumn" msprop:Generator_UserColumnName="hanmuctindung" type="xs:decimal" minOccurs="0" />
              <xs:element name="hanthanhtoan" msprop:Generator_ColumnVarNameInTable="columnhanthanhtoan" msprop:Generator_ColumnPropNameInRow="hanthanhtoan" msprop:Generator_ColumnPropNameInTable="hanthanhtoanColumn" msprop:Generator_UserColumnName="hanthanhtoan" type="xs:int" minOccurs="0" />
              <xs:element name="loaihinhkd" msprop:Generator_ColumnVarNameInTable="columnloaihinhkd" msprop:Generator_ColumnPropNameInRow="loaihinhkd" msprop:Generator_ColumnPropNameInTable="loaihinhkdColumn" msprop:Generator_UserColumnName="loaihinhkd" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ngayphatsinhgd" msprop:Generator_ColumnVarNameInTable="columnngayphatsinhgd" msprop:Generator_ColumnPropNameInRow="ngayphatsinhgd" msprop:Generator_ColumnPropNameInTable="ngayphatsinhgdColumn" msprop:Generator_UserColumnName="ngayphatsinhgd" type="xs:dateTime" minOccurs="0" />
              <xs:element name="ngaythanhlap" msprop:Generator_ColumnVarNameInTable="columnngaythanhlap" msprop:Generator_ColumnPropNameInRow="ngaythanhlap" msprop:Generator_ColumnPropNameInTable="ngaythanhlapColumn" msprop:Generator_UserColumnName="ngaythanhlap" type="xs:dateTime" minOccurs="0" />
              <xs:element name="nganhnghekd" msprop:Generator_ColumnVarNameInTable="columnnganhnghekd" msprop:Generator_ColumnPropNameInRow="nganhnghekd" msprop:Generator_ColumnPropNameInTable="nganhnghekdColumn" msprop:Generator_UserColumnName="nganhnghekd" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="fax" msprop:Generator_ColumnVarNameInTable="columnfax" msprop:Generator_ColumnPropNameInRow="fax" msprop:Generator_ColumnPropNameInTable="faxColumn" msprop:Generator_UserColumnName="fax" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="macu" msprop:Generator_ColumnVarNameInTable="columnmacu" msprop:Generator_ColumnPropNameInRow="macu" msprop:Generator_ColumnPropNameInTable="macuColumn" msprop:Generator_UserColumnName="macu" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="banggia" msprop:Generator_ColumnVarNameInTable="columnbanggia" msprop:Generator_ColumnPropNameInRow="banggia" msprop:Generator_ColumnPropNameInTable="banggiaColumn" msprop:Generator_UserColumnName="banggia" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="chietkhau" msprop:Generator_ColumnVarNameInTable="columnchietkhau" msprop:Generator_ColumnPropNameInRow="chietkhau" msprop:Generator_ColumnPropNameInTable="chietkhauColumn" msprop:Generator_UserColumnName="chietkhau" type="xs:decimal" minOccurs="0" />
              <xs:element name="giamgia" msprop:Generator_ColumnVarNameInTable="columngiamgia" msprop:Generator_ColumnPropNameInRow="giamgia" msprop:Generator_ColumnPropNameInTable="giamgiaColumn" msprop:Generator_UserColumnName="giamgia" type="xs:decimal" minOccurs="0" />
              <xs:element name="diachigiaohang" msprop:Generator_ColumnVarNameInTable="columndiachigiaohang" msprop:Generator_ColumnPropNameInRow="diachigiaohang" msprop:Generator_ColumnPropNameInTable="diachigiaohangColumn" msprop:Generator_UserColumnName="diachigiaohang" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="loaivitri" msprop:Generator_ColumnVarNameInTable="columnloaivitri" msprop:Generator_ColumnPropNameInRow="loaivitri" msprop:Generator_ColumnPropNameInTable="loaivitriColumn" msprop:Generator_UserColumnName="loaivitri" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="loaietc" msprop:Generator_ColumnVarNameInTable="columnloaietc" msprop:Generator_ColumnPropNameInRow="loaietc" msprop:Generator_ColumnPropNameInTable="loaietcColumn" msprop:Generator_UserColumnName="loaietc" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="chinhanh" msprop:Generator_ColumnVarNameInTable="columnchinhanh" msprop:Generator_ColumnPropNameInRow="chinhanh" msprop:Generator_ColumnPropNameInTable="chinhanhColumn" msprop:Generator_UserColumnName="chinhanh" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="tinhtrang" msprop:Generator_ColumnVarNameInTable="columntinhtrang" msprop:Generator_ColumnPropNameInRow="tinhtrang" msprop:Generator_ColumnPropNameInTable="tinhtrangColumn" msprop:Generator_UserColumnName="tinhtrang" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:decimal" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="ketoantienmat" msprop:Generator_TableClassName="ketoantienmatDataTable" msprop:Generator_TableVarName="tableketoantienmat" msprop:Generator_TablePropName="ketoantienmat" msprop:Generator_RowDeletingName="ketoantienmatRowDeleting" msprop:Generator_UserTableName="ketoantienmat" msprop:Generator_RowChangingName="ketoantienmatRowChanging" msprop:Generator_RowEvHandlerName="ketoantienmatRowChangeEventHandler" msprop:Generator_RowDeletedName="ketoantienmatRowDeleted" msprop:Generator_RowEvArgName="ketoantienmatRowChangeEvent" msprop:Generator_RowChangedName="ketoantienmatRowChanged" msprop:Generator_RowClassName="ketoantienmatRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ma" msprop:Generator_ColumnVarNameInTable="columnma" msprop:Generator_ColumnPropNameInRow="ma" msprop:Generator_ColumnPropNameInTable="maColumn" msprop:Generator_UserColumnName="ma">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="nghiepvu" msprop:Generator_ColumnVarNameInTable="columnnghiepvu" msprop:Generator_ColumnPropNameInRow="nghiepvu" msprop:Generator_ColumnPropNameInTable="nghiepvuColumn" msprop:Generator_UserColumnName="nghiepvu" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="sochungtu" msprop:Generator_ColumnVarNameInTable="columnsochungtu" msprop:Generator_ColumnPropNameInRow="sochungtu" msprop:Generator_ColumnPropNameInTable="sochungtuColumn" msprop:Generator_UserColumnName="sochungtu" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ngaylap" msprop:Generator_ColumnVarNameInTable="columnngaylap" msprop:Generator_ColumnPropNameInRow="ngaylap" msprop:Generator_ColumnPropNameInTable="ngaylapColumn" msprop:Generator_UserColumnName="ngaylap" type="xs:dateTime" minOccurs="0" />
              <xs:element name="hoten" msprop:Generator_ColumnVarNameInTable="columnhoten" msprop:Generator_ColumnPropNameInRow="hoten" msprop:Generator_ColumnPropNameInTable="hotenColumn" msprop:Generator_UserColumnName="hoten" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="bophan" msprop:Generator_ColumnVarNameInTable="columnbophan" msprop:Generator_ColumnPropNameInRow="bophan" msprop:Generator_ColumnPropNameInTable="bophanColumn" msprop:Generator_UserColumnName="bophan" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="donvi" msprop:Generator_ColumnVarNameInTable="columndonvi" msprop:Generator_ColumnPropNameInRow="donvi" msprop:Generator_ColumnPropNameInTable="donviColumn" msprop:Generator_UserColumnName="donvi" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="noidung" msprop:Generator_ColumnVarNameInTable="columnnoidung" msprop:Generator_ColumnPropNameInRow="noidung" msprop:Generator_ColumnPropNameInTable="noidungColumn" msprop:Generator_UserColumnName="noidung" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="thamchieu" msprop:Generator_ColumnVarNameInTable="columnthamchieu" msprop:Generator_ColumnPropNameInRow="thamchieu" msprop:Generator_ColumnPropNameInTable="thamchieuColumn" msprop:Generator_UserColumnName="thamchieu" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ngaylapthamchieu" msprop:Generator_ColumnVarNameInTable="columnngaylapthamchieu" msprop:Generator_ColumnPropNameInRow="ngaylapthamchieu" msprop:Generator_ColumnPropNameInTable="ngaylapthamchieuColumn" msprop:Generator_UserColumnName="ngaylapthamchieu" type="xs:dateTime" minOccurs="0" />
              <xs:element name="chungtukem" msprop:Generator_ColumnVarNameInTable="columnchungtukem" msprop:Generator_ColumnPropNameInRow="chungtukem" msprop:Generator_ColumnPropNameInTable="chungtukemColumn" msprop:Generator_UserColumnName="chungtukem" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="loaitien" msprop:Generator_ColumnVarNameInTable="columnloaitien" msprop:Generator_ColumnPropNameInRow="loaitien" msprop:Generator_ColumnPropNameInTable="loaitienColumn" msprop:Generator_UserColumnName="loaitien" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="tygia" msprop:Generator_ColumnVarNameInTable="columntygia" msprop:Generator_ColumnPropNameInRow="tygia" msprop:Generator_ColumnPropNameInTable="tygiaColumn" msprop:Generator_UserColumnName="tygia" type="xs:decimal" />
              <xs:element name="nguyente" msprop:Generator_ColumnVarNameInTable="columnnguyente" msprop:Generator_ColumnPropNameInRow="nguyente" msprop:Generator_ColumnPropNameInTable="nguyenteColumn" msprop:Generator_UserColumnName="nguyente" type="xs:decimal" minOccurs="0" />
              <xs:element name="tienvnd" msprop:Generator_ColumnVarNameInTable="columntienvnd" msprop:Generator_ColumnPropNameInRow="tienvnd" msprop:Generator_ColumnPropNameInTable="tienvndColumn" msprop:Generator_UserColumnName="tienvnd" type="xs:decimal" />
              <xs:element name="tinhtrang" msprop:Generator_ColumnVarNameInTable="columntinhtrang" msprop:Generator_ColumnPropNameInRow="tinhtrang" msprop:Generator_ColumnPropNameInTable="tinhtrangColumn" msprop:Generator_UserColumnName="tinhtrang" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="chinhanh" msprop:Generator_ColumnVarNameInTable="columnchinhanh" msprop:Generator_ColumnPropNameInRow="chinhanh" msprop:Generator_ColumnPropNameInTable="chinhanhColumn" msprop:Generator_UserColumnName="chinhanh" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:decimal" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="ketoantienmat_thongtinchinh" msprop:Generator_TableClassName="ketoantienmat_thongtinchinhDataTable" msprop:Generator_TableVarName="tableketoantienmat_thongtinchinh" msprop:Generator_TablePropName="ketoantienmat_thongtinchinh" msprop:Generator_RowDeletingName="ketoantienmat_thongtinchinhRowDeleting" msprop:Generator_UserTableName="ketoantienmat_thongtinchinh" msprop:Generator_RowChangingName="ketoantienmat_thongtinchinhRowChanging" msprop:Generator_RowEvHandlerName="ketoantienmat_thongtinchinhRowChangeEventHandler" msprop:Generator_RowDeletedName="ketoantienmat_thongtinchinhRowDeleted" msprop:Generator_RowEvArgName="ketoantienmat_thongtinchinhRowChangeEvent" msprop:Generator_RowChangedName="ketoantienmat_thongtinchinhRowChanged" msprop:Generator_RowClassName="ketoantienmat_thongtinchinhRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ma" msprop:Generator_ColumnVarNameInTable="columnma" msprop:Generator_ColumnPropNameInRow="ma" msprop:Generator_ColumnPropNameInTable="maColumn" msprop:Generator_UserColumnName="ma">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="taikhoanno" msprop:Generator_ColumnVarNameInTable="columntaikhoanno" msprop:Generator_ColumnPropNameInRow="taikhoanno" msprop:Generator_ColumnPropNameInTable="taikhoannoColumn" msprop:Generator_UserColumnName="taikhoanno" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="taikhoanco" msprop:Generator_ColumnVarNameInTable="columntaikhoanco" msprop:Generator_ColumnPropNameInRow="taikhoanco" msprop:Generator_ColumnPropNameInTable="taikhoancoColumn" msprop:Generator_UserColumnName="taikhoanco" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="nguyente" msprop:Generator_ColumnVarNameInTable="columnnguyente" msprop:Generator_ColumnPropNameInRow="nguyente" msprop:Generator_ColumnPropNameInTable="nguyenteColumn" msprop:Generator_UserColumnName="nguyente" type="xs:decimal" minOccurs="0" />
              <xs:element name="tienvnd" msprop:Generator_ColumnVarNameInTable="columntienvnd" msprop:Generator_ColumnPropNameInRow="tienvnd" msprop:Generator_ColumnPropNameInTable="tienvndColumn" msprop:Generator_UserColumnName="tienvnd" type="xs:decimal" minOccurs="0" />
              <xs:element name="diengiai" msprop:Generator_ColumnVarNameInTable="columndiengiai" msprop:Generator_ColumnPropNameInRow="diengiai" msprop:Generator_ColumnPropNameInTable="diengiaiColumn" msprop:Generator_UserColumnName="diengiai" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="donvi" msprop:Generator_ColumnVarNameInTable="columndonvi" msprop:Generator_ColumnPropNameInRow="donvi" msprop:Generator_ColumnPropNameInTable="donviColumn" msprop:Generator_UserColumnName="donvi" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="diachi" msprop:Generator_ColumnVarNameInTable="columndiachi" msprop:Generator_ColumnPropNameInRow="diachi" msprop:Generator_ColumnPropNameInTable="diachiColumn" msprop:Generator_UserColumnName="diachi" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="masothue" msprop:Generator_ColumnVarNameInTable="columnmasothue" msprop:Generator_ColumnPropNameInRow="masothue" msprop:Generator_ColumnPropNameInTable="masothueColumn" msprop:Generator_UserColumnName="masothue" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="sohoadon" msprop:Generator_ColumnVarNameInTable="columnsohoadon" msprop:Generator_ColumnPropNameInRow="sohoadon" msprop:Generator_ColumnPropNameInTable="sohoadonColumn" msprop:Generator_UserColumnName="sohoadon" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ngay" msprop:Generator_ColumnVarNameInTable="columnngay" msprop:Generator_ColumnPropNameInRow="ngay" msprop:Generator_ColumnPropNameInTable="ngayColumn" msprop:Generator_UserColumnName="ngay" type="xs:dateTime" minOccurs="0" />
              <xs:element name="khoanmuc" msprop:Generator_ColumnVarNameInTable="columnkhoanmuc" msprop:Generator_ColumnPropNameInRow="khoanmuc" msprop:Generator_ColumnPropNameInTable="khoanmucColumn" msprop:Generator_UserColumnName="khoanmuc" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="phongban" msprop:Generator_ColumnVarNameInTable="columnphongban" msprop:Generator_ColumnPropNameInRow="phongban" msprop:Generator_ColumnPropNameInTable="phongbanColumn" msprop:Generator_UserColumnName="phongban" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="hangmuc" msprop:Generator_ColumnVarNameInTable="columnhangmuc" msprop:Generator_ColumnPropNameInRow="hangmuc" msprop:Generator_ColumnPropNameInTable="hangmucColumn" msprop:Generator_UserColumnName="hangmuc" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="hopdong" msprop:Generator_ColumnVarNameInTable="columnhopdong" msprop:Generator_ColumnPropNameInRow="hopdong" msprop:Generator_ColumnPropNameInTable="hopdongColumn" msprop:Generator_UserColumnName="hopdong" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="nguonvon" msprop:Generator_ColumnVarNameInTable="columnnguonvon" msprop:Generator_ColumnPropNameInRow="nguonvon" msprop:Generator_ColumnPropNameInTable="nguonvonColumn" msprop:Generator_UserColumnName="nguonvon" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:decimal" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="ketoantienmat_thongtinthue" msprop:Generator_TableClassName="ketoantienmat_thongtinthueDataTable" msprop:Generator_TableVarName="tableketoantienmat_thongtinthue" msprop:Generator_TablePropName="ketoantienmat_thongtinthue" msprop:Generator_RowDeletingName="ketoantienmat_thongtinthueRowDeleting" msprop:Generator_UserTableName="ketoantienmat_thongtinthue" msprop:Generator_RowChangingName="ketoantienmat_thongtinthueRowChanging" msprop:Generator_RowEvHandlerName="ketoantienmat_thongtinthueRowChangeEventHandler" msprop:Generator_RowDeletedName="ketoantienmat_thongtinthueRowDeleted" msprop:Generator_RowEvArgName="ketoantienmat_thongtinthueRowChangeEvent" msprop:Generator_RowChangedName="ketoantienmat_thongtinthueRowChanged" msprop:Generator_RowClassName="ketoantienmat_thongtinthueRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ma" msprop:Generator_ColumnVarNameInTable="columnma" msprop:Generator_ColumnPropNameInRow="ma" msprop:Generator_ColumnPropNameInTable="maColumn" msprop:Generator_UserColumnName="ma">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="sohoadon" msprop:Generator_ColumnVarNameInTable="columnsohoadon" msprop:Generator_ColumnPropNameInRow="sohoadon" msprop:Generator_ColumnPropNameInTable="sohoadonColumn" msprop:Generator_UserColumnName="sohoadon" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="soserie" msprop:Generator_ColumnVarNameInTable="columnsoserie" msprop:Generator_ColumnPropNameInRow="soserie" msprop:Generator_ColumnPropNameInTable="soserieColumn" msprop:Generator_UserColumnName="soserie" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="loaihoadon" msprop:Generator_ColumnVarNameInTable="columnloaihoadon" msprop:Generator_ColumnPropNameInRow="loaihoadon" msprop:Generator_ColumnPropNameInTable="loaihoadonColumn" msprop:Generator_UserColumnName="loaihoadon" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ngayhoadon" msprop:Generator_ColumnVarNameInTable="columnngayhoadon" msprop:Generator_ColumnPropNameInRow="ngayhoadon" msprop:Generator_ColumnPropNameInTable="ngayhoadonColumn" msprop:Generator_UserColumnName="ngayhoadon" type="xs:dateTime" minOccurs="0" />
              <xs:element name="tenhang" msprop:Generator_ColumnVarNameInTable="columntenhang" msprop:Generator_ColumnPropNameInRow="tenhang" msprop:Generator_ColumnPropNameInTable="tenhangColumn" msprop:Generator_UserColumnName="tenhang" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="donvi" msprop:Generator_ColumnVarNameInTable="columndonvi" msprop:Generator_ColumnPropNameInRow="donvi" msprop:Generator_ColumnPropNameInTable="donviColumn" msprop:Generator_UserColumnName="donvi" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="diachi" msprop:Generator_ColumnVarNameInTable="columndiachi" msprop:Generator_ColumnPropNameInRow="diachi" msprop:Generator_ColumnPropNameInTable="diachiColumn" msprop:Generator_UserColumnName="diachi" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="masothue" msprop:Generator_ColumnVarNameInTable="columnmasothue" msprop:Generator_ColumnPropNameInRow="masothue" msprop:Generator_ColumnPropNameInTable="masothueColumn" msprop:Generator_UserColumnName="masothue" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="doanhthu" msprop:Generator_ColumnVarNameInTable="columndoanhthu" msprop:Generator_ColumnPropNameInRow="doanhthu" msprop:Generator_ColumnPropNameInTable="doanhthuColumn" msprop:Generator_UserColumnName="doanhthu" type="xs:decimal" minOccurs="0" />
              <xs:element name="phantramthue" msprop:Generator_ColumnVarNameInTable="columnphantramthue" msprop:Generator_ColumnPropNameInRow="phantramthue" msprop:Generator_ColumnPropNameInTable="phantramthueColumn" msprop:Generator_UserColumnName="phantramthue" type="xs:int" minOccurs="0" />
              <xs:element name="thue" msprop:Generator_ColumnVarNameInTable="columnthue" msprop:Generator_ColumnPropNameInRow="thue" msprop:Generator_ColumnPropNameInTable="thueColumn" msprop:Generator_UserColumnName="thue" type="xs:decimal" minOccurs="0" />
              <xs:element name="tongcong" msprop:Generator_ColumnVarNameInTable="columntongcong" msprop:Generator_ColumnPropNameInRow="tongcong" msprop:Generator_ColumnPropNameInTable="tongcongColumn" msprop:Generator_UserColumnName="tongcong" type="xs:decimal" minOccurs="0" />
              <xs:element name="chinhanh" msprop:Generator_ColumnVarNameInTable="columnchinhanh" msprop:Generator_ColumnPropNameInRow="chinhanh" msprop:Generator_ColumnPropNameInTable="chinhanhColumn" msprop:Generator_UserColumnName="chinhanh" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:decimal" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="dmnganhang" msprop:Generator_TableClassName="dmnganhangDataTable" msprop:Generator_TableVarName="tabledmnganhang" msprop:Generator_TablePropName="dmnganhang" msprop:Generator_RowDeletingName="dmnganhangRowDeleting" msprop:Generator_UserTableName="dmnganhang" msprop:Generator_RowChangingName="dmnganhangRowChanging" msprop:Generator_RowEvHandlerName="dmnganhangRowChangeEventHandler" msprop:Generator_RowDeletedName="dmnganhangRowDeleted" msprop:Generator_RowEvArgName="dmnganhangRowChangeEvent" msprop:Generator_RowChangedName="dmnganhangRowChanged" msprop:Generator_RowClassName="dmnganhangRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ma" msprop:Generator_ColumnVarNameInTable="columnma" msprop:Generator_ColumnPropNameInRow="ma" msprop:Generator_ColumnPropNameInTable="maColumn" msprop:Generator_UserColumnName="ma">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ten" msprop:Generator_ColumnVarNameInTable="columnten" msprop:Generator_ColumnPropNameInRow="ten" msprop:Generator_ColumnPropNameInTable="tenColumn" msprop:Generator_UserColumnName="ten">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ghichu" msprop:Generator_ColumnVarNameInTable="columnghichu" msprop:Generator_ColumnPropNameInRow="ghichu" msprop:Generator_ColumnPropNameInTable="ghichuColumn" msprop:Generator_UserColumnName="ghichu" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="chinhanh" msprop:Generator_ColumnVarNameInTable="columnchinhanh" msprop:Generator_ColumnPropNameInRow="chinhanh" msprop:Generator_ColumnPropNameInTable="chinhanhColumn" msprop:Generator_UserColumnName="chinhanh" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="tinhtrang" msprop:Generator_ColumnVarNameInTable="columntinhtrang" msprop:Generator_ColumnPropNameInRow="tinhtrang" msprop:Generator_ColumnPropNameInTable="tinhtrangColumn" msprop:Generator_UserColumnName="tinhtrang">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:decimal" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="dmtaikhoannganhang" msprop:Generator_TableClassName="dmtaikhoannganhangDataTable" msprop:Generator_TableVarName="tabledmtaikhoannganhang" msprop:Generator_TablePropName="dmtaikhoannganhang" msprop:Generator_RowDeletingName="dmtaikhoannganhangRowDeleting" msprop:Generator_UserTableName="dmtaikhoannganhang" msprop:Generator_RowChangingName="dmtaikhoannganhangRowChanging" msprop:Generator_RowEvHandlerName="dmtaikhoannganhangRowChangeEventHandler" msprop:Generator_RowDeletedName="dmtaikhoannganhangRowDeleted" msprop:Generator_RowEvArgName="dmtaikhoannganhangRowChangeEvent" msprop:Generator_RowChangedName="dmtaikhoannganhangRowChanged" msprop:Generator_RowClassName="dmtaikhoannganhangRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ma" msprop:Generator_ColumnVarNameInTable="columnma" msprop:Generator_ColumnPropNameInRow="ma" msprop:Generator_ColumnPropNameInTable="maColumn" msprop:Generator_UserColumnName="ma">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="manganhang" msprop:Generator_ColumnVarNameInTable="columnmanganhang" msprop:Generator_ColumnPropNameInRow="manganhang" msprop:Generator_ColumnPropNameInTable="manganhangColumn" msprop:Generator_UserColumnName="manganhang">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="makhachhang" msprop:Generator_ColumnVarNameInTable="columnmakhachhang" msprop:Generator_ColumnPropNameInRow="makhachhang" msprop:Generator_ColumnPropNameInTable="makhachhangColumn" msprop:Generator_UserColumnName="makhachhang">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="noidung" msprop:Generator_ColumnVarNameInTable="columnnoidung" msprop:Generator_ColumnPropNameInRow="noidung" msprop:Generator_ColumnPropNameInTable="noidungColumn" msprop:Generator_UserColumnName="noidung" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="taikhoankt" msprop:Generator_ColumnVarNameInTable="columntaikhoankt" msprop:Generator_ColumnPropNameInRow="taikhoankt" msprop:Generator_ColumnPropNameInTable="taikhoanktColumn" msprop:Generator_UserColumnName="taikhoankt" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="matinh" msprop:Generator_ColumnVarNameInTable="columnmatinh" msprop:Generator_ColumnPropNameInRow="matinh" msprop:Generator_ColumnPropNameInTable="matinhColumn" msprop:Generator_UserColumnName="matinh">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="maloaitien" msprop:Generator_ColumnVarNameInTable="columnmaloaitien" msprop:Generator_ColumnPropNameInRow="maloaitien" msprop:Generator_ColumnPropNameInTable="maloaitienColumn" msprop:Generator_UserColumnName="maloaitien" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="chinhanh" msprop:Generator_ColumnVarNameInTable="columnchinhanh" msprop:Generator_ColumnPropNameInRow="chinhanh" msprop:Generator_ColumnPropNameInTable="chinhanhColumn" msprop:Generator_UserColumnName="chinhanh" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="tinhtrang" msprop:Generator_ColumnVarNameInTable="columntinhtrang" msprop:Generator_ColumnPropNameInRow="tinhtrang" msprop:Generator_ColumnPropNameInTable="tinhtrangColumn" msprop:Generator_UserColumnName="tinhtrang">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:decimal" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="donvisudung" msprop:Generator_TableClassName="donvisudungDataTable" msprop:Generator_TableVarName="tabledonvisudung" msprop:Generator_TablePropName="donvisudung" msprop:Generator_RowDeletingName="donvisudungRowDeleting" msprop:Generator_UserTableName="donvisudung" msprop:Generator_RowChangingName="donvisudungRowChanging" msprop:Generator_RowEvHandlerName="donvisudungRowChangeEventHandler" msprop:Generator_RowDeletedName="donvisudungRowDeleted" msprop:Generator_RowEvArgName="donvisudungRowChangeEvent" msprop:Generator_RowChangedName="donvisudungRowChanged" msprop:Generator_RowClassName="donvisudungRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ten" msprop:Generator_ColumnVarNameInTable="columnten" msprop:Generator_ColumnPropNameInRow="ten" msprop:Generator_ColumnPropNameInTable="tenColumn" msprop:Generator_UserColumnName="ten">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="diachi" msprop:Generator_ColumnVarNameInTable="columndiachi" msprop:Generator_ColumnPropNameInRow="diachi" msprop:Generator_ColumnPropNameInTable="diachiColumn" msprop:Generator_UserColumnName="diachi">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="logo" msprop:Generator_ColumnVarNameInTable="columnlogo" msprop:Generator_ColumnPropNameInRow="logo" msprop:Generator_ColumnPropNameInTable="logoColumn" msprop:Generator_UserColumnName="logo" type="xs:base64Binary" />
              <xs:element name="dienthoai" msprop:Generator_ColumnVarNameInTable="columndienthoai" msprop:Generator_ColumnPropNameInRow="dienthoai" msprop:Generator_ColumnPropNameInTable="dienthoaiColumn" msprop:Generator_UserColumnName="dienthoai" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="fax" msprop:Generator_ColumnVarNameInTable="columnfax" msprop:Generator_ColumnPropNameInRow="fax" msprop:Generator_ColumnPropNameInTable="faxColumn" msprop:Generator_UserColumnName="fax" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="email" msprop:Generator_ColumnVarNameInTable="columnemail" msprop:Generator_ColumnPropNameInRow="email" msprop:Generator_ColumnPropNameInTable="emailColumn" msprop:Generator_UserColumnName="email" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:dmkhachhang" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="ketoantienmat_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:ketoantienmat" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="ketoantienmat_thongtinchinh_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:ketoantienmat_thongtinchinh" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="ketoantienmat_thongtinthue_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:ketoantienmat_thongtinthue" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="dmnganhang_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:dmnganhang" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="dmtaikhoannganhang_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:dmtaikhoannganhang" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK_ketoantienmat_thongtinchinh_ketoantienmat" msdata:parent="ketoantienmat" msdata:child="ketoantienmat_thongtinchinh" msdata:parentkey="ma" msdata:childkey="ma" msprop:Generator_UserChildTable="ketoantienmat_thongtinchinh" msprop:Generator_ChildPropName="Getketoantienmat_thongtinchinhRows" msprop:Generator_ParentPropName="ketoantienmatRow" msprop:Generator_UserRelationName="FK_ketoantienmat_thongtinchinh_ketoantienmat" msprop:Generator_RelationVarName="relationFK_ketoantienmat_thongtinchinh_ketoantienmat" msprop:Generator_UserParentTable="ketoantienmat" />
      <msdata:Relationship name="FK_ketoantienmat_thongtinthue_ketoantienmat" msdata:parent="ketoantienmat" msdata:child="ketoantienmat_thongtinthue" msdata:parentkey="ma" msdata:childkey="ma" msprop:Generator_UserChildTable="ketoantienmat_thongtinthue" msprop:Generator_ChildPropName="Getketoantienmat_thongtinthueRows" msprop:Generator_ParentPropName="ketoantienmatRow" msprop:Generator_UserRelationName="FK_ketoantienmat_thongtinthue_ketoantienmat" msprop:Generator_RelationVarName="relationFK_ketoantienmat_thongtinthue_ketoantienmat" msprop:Generator_UserParentTable="ketoantienmat" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>